Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there
I have DAX code and my question how to make the Customer[Birthday] -- to make it dynamic as a slicer
Solved! Go to Solution.
Hi @Oded-Dror ,
Create a calendar table like:
calendar = calendarauto()
Then create a date-between slicer use the date column in calendar table.
At last, modify the formula as below:
Nothing return
Hi @Oded-Dror ,
Create a calendar table like:
calendar = calendarauto()
Then create a date-between slicer use the date column in calendar table.
At last, modify the formula as below:
With this approch it show nothing so I changed it to
Customer[Birthday] >= MIN('Customer'[Birthdate]) && Customer[Birthday] <= MAX('Customer'[Birthdate])
And it works as a measure
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |