Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
83 | |
76 | |
71 | |
69 | |
53 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |