Forum Discussion
measures on rows matrix
Hi, Is it possible to have measures on rows in a matrix? I know there is an option in format-values and turn on "show on rows" But what I further want to achieve is for example: ...
Hi Anonymous ,
I was assuming that those were columns on your data, can you please a sample share, as amitchandak you need to make a use between switch function and an auxiliary table.
Regards,
MFelix
Tnx, I only get one column with the measures.
I need columns for example: last year, TYD and TYD-1
One option is union and summarize
union ( summarize( table[group_by1],table[group_by1],"measure","Sales","MTD",<MTD formula>, "YTD",<Ytd Formul>...),
summarize( table[group_by1],table[group_by1],"measure","Cost","MTD",<MTD formula>, "YTD",<Ytd Formul>...)
...
)
Group, add constant value for measure name and MTD, QTD, YTD, last year etc.