Forum Discussion
Dynamic variable calendar for column chart
In my report I have a calendar slicer set to "Before". The use case is, users will select the "to date" of the slicer and the report will display data relative to the sele...
PowerBI_Canuck I don't fully understand your scenario yet as the Ei 1 and Ei 2 examples you have provided have a date selected in the middle of the range provided. What do you want your date table to look like in the end?
I prefer to create the Date table in Power Query. Then you can add a conditional column for the ERP start and end dates, and use those in your slicer if I'm understanding your problem correctly?
https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html