Forum Discussion
Solved
Report automation
Hi guys, I have a problem with process automation in Power BI. For my report and for this case I have two datasets: - ACTUAL sales values (Jan - not complete July) - Latest view sales values...
PavelP,
Please create a MonthNumber column in your calendar table if you don't have the column, then check if one of the following DAX returns your expected result.Measure = VAR CURRENTMONTH= FORMAT(NOW(),"MMM") RETURN CALCULATE(SUM('Latest view_FC'[Sales Orders - Latest view]),'Calendar'[Month]=CURRENTMONTH)+CALCULATE(Sales_NetSuite[Sales(ACT)],'Calendar'[MonthNumber] <=MONTH(NOW()) && 'Calendar'[MonthNumber]>=1)Measure1 = CALCULATE(SUM('Latest view_FC'[Sales Orders - Latest view],'Calendar'[MonthNumber] =MONTH(NOW())-1)+CALCULATE(Sales_NetSuite[Sales(ACT)],'Calendar'[MonthNumber] <=MONTH(NOW())-1 && 'Calendar'[MonthNumber] >=1)
Regards,Lydia
PavelP,
Please create a MonthNumber column in your calendar table if you don't have the column, then check if one of the following DAX returns your expected result.
Measure = VAR CURRENTMONTH= FORMAT(NOW(),"MMM") RETURN CALCULATE(SUM('Latest view_FC'[Sales Orders - Latest view]),'Calendar'[Month]=CURRENTMONTH)+CALCULATE(Sales_NetSuite[Sales(ACT)],'Calendar'[MonthNumber] <=MONTH(NOW()) && 'Calendar'[MonthNumber]>=1)
Measure1 = CALCULATE(SUM('Latest view_FC'[Sales Orders - Latest view],'Calendar'[MonthNumber] =MONTH(NOW())-1)+CALCULATE(Sales_NetSuite[Sales(ACT)],'Calendar'[MonthNumber] <=MONTH(NOW())-1 && 'Calendar'[MonthNumber] >=1)
Regards,
Lydia
Hi Lydia,
it looks that everything is working perfectly!!!!!
Great!!!! Thank you very much!
Pavel
