Forum Discussion

AustralPRB's avatar
AustralPRB
Frequent Visitor
8 years ago
Solved

Error in YTD Calc

I am trying to finish a P&L Report        Essentially I have  GL Actual , Budget , Var1 , YTD GL Actual , YTD Budget Var2           When I filter for June 2018 Branch 20  Service   600  T...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi AustralPRB,

     

    The root cause is no data of "Sundry Income" of June exists. The possible solution could be like below.

    GL YTD =
CALCULATE ( TOTALYTD ( [GL Actual], dDate[Date] ), ALL ( dDate[Month] ) )

    Error_in_YTD_Calc

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi AustralPRB,

 

Can you share the file? You can delete or mask the sensitive parts.

 

Best Regards,

Dale

AustralPRB's avatar
AustralPRB
Frequent Visitor
8 years ago

I can send you pbix file