Forum Discussion
Table Visualization
Hi All, I am trying to obtain similar solution as shown below in Table visualization. I know I can do with matrix visualization easily but I have other calculated measures I need to add to this so I...
To do that, you would need to create separate measures for each column like this
Week 1 = CALCULATE([Your Measure], Source[Week] = 1)
Week 2 = CALCULATE([Your Measure], Source[Week] = 2)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi Anonymous,
You can take a look at the following blog about pivot column to expand your value fields to columns if they meet to your requirement:
The New Pivot Column option in Power Query
Regards,
Xiaoxin Sheng