WoW dax formula that iterates over multiple rows of data and measures in a matrix visual.

[Anonymous]

I am fairly new to Power BI and was trying to get a time intelligence measure for WoW that would iterate over multiple values and return the WoW variance of whatever is in the value field.

The picture above shows how i would like the matrix table to look. the delta signs indicate WoW change and now show how WoW calculations through individual measures. I would like one measure that I can put in the column section to iterate over each value in the rows. Any suggestions?

[v-yalanwu-msft]

Hi, @Anonymous ;

Can you elaborate on the logic of your WOW dax based on the data and scenarios you shared for further solution? Or sharing  pbix whitout any sensitive information ? because I don't clear your logic for your dax. thank you!

[Anonymous]

So at the moment I have a WoW calculation for each value seperately.  Then I overlay that with the regular date column table and change the header with a text box to make it look like it's still part of the same table.
The WoW Dax expression for each individual value is something like

SALES WoW = SUM('F&B'[F&B SALES]) - [SALESpw]

I'm fine with combining the tables but I was wondering if there was any way to get a line of DAX that is something like

WoW = (Selectedvalue current week) - (selectedvalue prior week)

Where the values are the rows and the column of the matrix is WoW or MoM or WoW% like 

values	WoW
Hotel Sales	(WoW Hotel Sales value)
Hotel Cash	(WoW Hotel Cash value)

[amitchandak]

@Anonymous , if you looking for that kind of display. That is not supported. You need to have measures for all days. Or try the hybrid alternate .

For WoW you can refer my blogs

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

[Anonymous]

The Matrix Layout is not important, I am wondering if there is a way to write a WoW DAX measure that acts like a dimension for the values to iterate over like a date column would.