Hello
I am trying to get this (snip from excel)
but so far I am able to get all the columns except the variances/differences columns. Any idea/help?
Using this table for the headers in the matrix.
Thanks
Anyone? - Thanks
Hi @AlokBhardwaj ,
Regarding your questions - it seems for Q1-Q4 you do not have headers with variances + check your measures context for measures that you are using for measure branching (i.e. [2024 RF_1+11], [2024 RF_2+10] ) - will that be calculated for your variance context also ?
Then if you need further assistance - could you provide sample pbix file ?
Thanks.
Answer:
Seems like your header name in the Layout[Header] column is different than the text you use in the SWITCH(). Check spelling, spaces, etc - or copy/paste it to be sure.