Forum Discussion
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 supposed to show the Total Volumes YTD and both are supposed to correspond to the slicer choice. For example, I want the Table 1 to show volumes for October only and Table 1 to show Volumes for January to October. To my limited understanding it seems that a potential solution could be to use on of the many DAX date-functions, the problem with that is that the data source I am using does not have a low level of granularity i.e. it is in YYYY-DD format. As such, it is not possible to create a tables containing the dates as it will contain inunique values after filling in one year. The second problem I am experiencing is that even though I create two different tables, the slicer selection for Table 1 impacts both table show the table supposed to show YTD volumes only shows the current month. In PowerPivot it was quite simple to use the "report connections" and uncheck the different tables but I have not been able to locate a similar feature yet. Does anyone have a workaround/solution to my problem? I hope it is clear enough, thank you in advance!
4 Replies
- TomMartensSuper User
Hey Newbie_1
welcome to this forum.
Unfortunately, it's almost impossible to answer your question, without more information, and a glimpse of your data. Consider to provide samples data, upload the pbix and/or xlsx the files to onedrive or dropbox and share the link.
You have to know, that all the build-in time-intelligence functions just work, with a dedicatec calendar table, that contains all the dates (days) for the time range you want to cover, meaning that is available in your data.
Maybe this porivdes more information: https://www.daxpatterns.com/time-patterns/
Hopefully this gets you started.
Regards,
Tom
- Newbie_1Frequent Visitor
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_1Frequent Visitor
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.