Forum Discussion
Solved
Combining like measures for different tables
I have 5 tables all with their own seperate Total Revenue Calculation formulas. In each table I have created a Total Revenue Measure. Now I would like one big table that shows all the Total revenue m...
Hi nhodges ,
Is this what you want? Define the row header first, and then you can define which measure to use in each row.
I have a dummy file for reference, please replace the table and measure to your own. Thanks.
You're awesome thank you!
If I wanted to break it down month over month afterwards so something like this:
Would I follow similar steps? and just add on to the formula? but I wouldnt want to have to add a month each time, no sure if theres a way for that, but I can keep playing around with it.
Hi nhodges ,
I think it depends on the relationships in your data model, but ideally you can create a matrix and put the month column into the row. Thanks.