Forum Discussion

awolf88's avatar
awolf88
Icon for Helper II rankHelper II
4 years ago
Solved

MTD Budget Measure Displays wrong

Dear community,   I'm having an issue displaying an accurate MTD Budget value within a card.   Basically I've broken down a monthly Budget into "m Daily Budget Allocation" as displayed. It corresp...
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    Hi awolf88 

     

    Please try this Measure.

    UmsatzToToday = CALCULATE([m MTD Umsatz SOLL],FILTER('Calendar','Calendar'[Date]=TODAY()))

     

    If it doesn’t work, could you please tell me how you create [m Umsatz SOLL] measure and the relationship between Calendar table and Budget 2021 table? Thanks in advance.

     

    Best Regards,

    Community Support Team _ Caiyun

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi awolf88 

 

Please try this Measure.

UmsatzToToday = CALCULATE([m MTD Umsatz SOLL],FILTER('Calendar','Calendar'[Date]=TODAY()))

 

If it doesn’t work, could you please tell me how you create [m Umsatz SOLL] measure and the relationship between Calendar table and Budget 2021 table? Thanks in advance.

 

Best Regards,

Community Support Team _ Caiyun

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!

awolf88's avatar
awolf88
Icon for Helper II rankHelper II
4 years ago

Wow! That filter-measure totally did the trick for everything that i needed!

Thank you all so very much for your help!

 

Best regards