Forum Discussion
mb0307
Responsive Resident
Responsive ResidentTotal based on month
Hi guys, Download PBIX File I have two tables, Forecast and Sales. Based on FORECAST PLANNING MONTH column, I would like to show to Total like this. Sample data is in uploaded PBI...
mb0307Responsive Resident
Responsive Residentlbendlin Thanks you much for sending the solution.
Sorry for not being clear but I want to show Forecast values in the table and ONLY change the total (forecast + actuals).
Like red boxes below:
lbendlin
Super User
Super UserYou can change the measure accordingly (remove the first option in the switch)