pivot on SSDT 2017

• Angel DBA Mex

  Ten Centuries

  Points: 1024

  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

• Site Owners

  SSC Guru

  Points: 80385

  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.

• pietlinden

  SSC Guru

  Points: 62394

  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 4 weeks, 1 day ago by  pietlinden.