pivot on SSDT 2017

  • Angel DBA Mex

    Ten Centuries

    Points: 1024

    Good Morning everyone

    I have a problem with a tabular Project on SSDT 2017, I have a 1 table with columns Q1, Q2, Q3 & Q4, I need to Pivot this columns, the manual say that I used the transform Menu, but I dont Find this Menu, Could anyone help me please.

    I appreciate your atention

    Attachments:
    You must be logged in to view attached files.

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • pietlinden

    SSC Guru

    Points: 62394

    Can you get the data before it's pivoted, so there are dates in there instead of quarters? Normally in a tabular model, your fact table will have a date or a date key and then that connects to a Calendar table, which has all the attributes you want to slice/pivot on. (So Quarter would be one of the columns).

    I'd do the pivot in the reporting tool... PowerBI, SSRS, whatever.

     

     

    • This reply was modified 4 weeks, 1 day ago by  pietlinden.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply