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:
this month last year TYD TYD-1
Sales Cost and results are all measures..
Solved! Go to Solution.
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.
We have great updates this month! Click the link for the video with more info.