Table Visualization

[Anonymous]

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 am doing in Table visual. To be precise I am looking for current week and going forward. Can you please help me.

Thanks

Sush

[Anonymous]

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

[mahoneypat · Accepted solution]

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

[Anonymous]

@mahoneypat -

This works. Thankyou! I was also looking for date for column name instead of week1, week 2 etc. like Aug 17 , Aug  24. Do you know how can i do it dynamic.

[mahoneypat]

I don't think you can dynamically name your measure, but you could provide the Week Date in the result concatenated with the result (e.g., <Date expression> & " - " & CALCULATE(...), but that probably isn't what you are looking for.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

@mahoneypat - Sure will try it. Thanks!