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

[mhtmshr07]

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!

[Anonymous]

Hi @mhtmshr07 ,

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.