Post reply

pivot on SSDT 2017

  • July 18, 2019 at 8:48 am

    #3664064

    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

  • July 19, 2019 at 9:10 am

    #3664444

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

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

  • July 19, 2019 at 2:13 pm

    #3664540

    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 5 years, 4 months ago by  pietlinden.

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

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