Forum Discussion

Newbie_1's avatar
Newbie_1
Frequent Visitor
6 years ago

YTD Calculation based on Slicer

Hi everyone,   I am pretty new to this amazing tool and I have run into a problem. I want to create two different tables where Table 1 is showing Total Volumes for the Actual month and Table 2 is ...
Need Help
Newbie_1's avatar
Newbie_1
Frequent Visitor
6 years ago

TomMartens

Hi! Thank you for your kind effort! Let me try to simplify the probelm: What DAX would you recommend to use if I want to calculate YTD volumes and the level of granulairty of my database is categorized only by months? 

Newbie_1's avatar
Newbie_1
Frequent Visitor
6 years ago

The left table is showing Actuals for the specific month based on the slicer selection. I would like that the right-handed table calculated Actuals from January to September.

                        

  • Newbie_1's avatar
    Newbie_1
    Frequent Visitor
    6 years ago

    My apologies for the spamming of messages.

     

    Alternatively: How can I prevent one table/figure to correspond to the actions of the slicer selections?

     

    Have a nice day!