Hope everyone is staying safe during this time.
I am trying to replicate a report in Power BI. The analysis is aiming to show:
- Products (main context) total sales for the last 2 months, followed by;
- Total sales for the last 3 days of the current month;
- Then some analysis for :
*VS Previous: compare the last 2 days
*VS %: % change last 2 days
*MTD: Last sales for the product VS Last month
*MTD %: % change
*Var to Budget: (Total current month - Total budget for the current month)
Sample report view to help illustrate the above
I think I am struggling to build a measure that will work with two different date table, which I know it’s hard. Not sure if it is possible to have 2 date tables on one page? If yes, any workaround to have them in one matrix table? Any suggestions would be highly appreciated.
PBXI file attached. Dashboard Test.pbix (688.0 KB)