Forum Discussion
How to filter based on an input date
Hello, I would like to filter my data based on a date input. Create a slider like to determine a day in the month and use that value inside of measures. How could I create that (the input & the ...
I do have 2 dates columns that I want to filter, but I want to filter both of them but only the day.
Would there be any way to do it ?
Jeanxyz
Power Participant
Power Participant@fzpokg, Are both columns in the same table? It's not a typical solution, but you can link both date columns to dim_calendar table, but Power BI only allows one active relationship, the other one will be inactive. You can enable the inactive relationship via userelationship().
Here is DAX guide on userelationship()
https://dax.guide/userelationship/
Both are in the same Table, but I would like to be able to use the day number to filter on another table.