Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Please help whit measure

Hello everyone, I try to calculate a daily average, a daily average last month, the percentage change from month to month, and the change in money from month to month. (Also for budget table) One o...
Need Help
  • netanel's avatar
    netanel
    4 years ago

    I found the right formulas Thanks!
    these are: 

    Diff$ Budget V =
    Var _MTDA = CALCULATE([MTD Sales],Sheet1[Data Surce]="A")
    return
    _MTDA-[MTD Sales for Budget 2021 V]
     
    Net USD % difference Budget V =
    Var _MTDA = CALCULATE([MTD Sales],Sheet1[Data Surce]="A")
    return
    (_MTDA-[MTD Sales for Budget 2021 V])/_MTDA
     
     
     
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, netanel ;

I haved open your pbix but I'm not sure what you want the output to be and the logic, maybe change the DATESMTD.Hope to share more details.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.