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
     
     
     
netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago

amitchandak 

 

Please see in the attached picture,
I changed to your formulas and still the budget table is wrong (marked in yellow) by the way my formulas was also good before just did not work in the budget table
Can you also look at the PBIX file I shared and my database Please

 

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
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