Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Using values in date column as headers, pivot to get other column values in new created columns

Hi all, 

The below screenshot is how I have the data available in raw form and another screenshot is the mockup of how I want the final visualization in Power BI. 

There are multiple values in the _Load_Date column(weekly snapshots) and Org_Name is getting repeated for each week.   


I am trying to see values in _Load_Date column as new columns(Current Week and Previous Week) and the values from  Plan_Launch_Grow populated inside Current_Week and Previous_Week (new columns) correspondingly for that week's snapshot. 
 Same thing for % change in LIC_UTL (License_Utlization) and Ratio_Of_Active_Users.



Screenshot 1 (raw data)

  

Screenshot 2 (mockup)

More than happy to explain more if needed.
Thank you so much for your help!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    It's possible. There's a matrix visual you want in Power BI Desktop.

    And about Current Week and Previous Week, you could use the WEEKNUM() function to return the week number within a year in Desktop or the solution completed in Power Query: 

    powerbi - Display previous week value and difference in Power BI - Stack Overflow

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.