Forum Discussion
Creating a DAX Expression for Rolling Dates Based on Selected Month in Power BI in (direct query)
I’m working on a Power BI report where I have a date slicer based on a ‘Date’ column from a table. When I select a date from the slicer, I want the report to display all dates that fall on the same d...
I’m working on a Power BI report where I have a date slicer based on a ‘Date’ column from a table. When I select a date from the slicer, I want the report to display all dates that fall on the same day and month across different years.
For example, if I select ‘5-31-2011’ from the slicer, the report should display ‘5-31-2011’, ‘5-31-2012’, ‘5-31-2013’, and so on. Essentially, I need rolling dates based on the selected day from the selected month.
I understand that I need to write a DAX expression to achieve this, but I’m not sure how to go about it. I would appreciate any guidance or sample DAX expressions that could help me achieve this functionality. Please note that I would like to implement this without using my specific table and column names.
Thanks in advance for your help!
many to many relationship