Forum Discussion

PavelP's avatar
PavelP
Frequent Visitor
8 years ago
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...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the datasets and also show the expected result.