mb0307Responsive Resident4 years agoTotal 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...Show More
mb0307Responsive Resident4 years agolbendlin 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:
lbendlinSuper User to mb03074 years agoYou can change the measure accordingly (remove the first option in the switch)
Related contentCummulative YTD Totals By Month ErrorTotal per month / average per monthCalculating running total based on monthPartitioning based on Year-MonthCumulative Total Based on Month and Year
