Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to get the number of days on the date slicer to compute a measure by group show it on a chart.
As a measure this is not a problem.
The chalange is how to get the number of days and use it on a calculated table?
I added the file with an example.
https://1drv.ms/f/s!AuFm6kI8W45mgc0CoXZk7JbGbk3Phg
Thank you in advance.
All the best
Joao
Solved! Go to Solution.
Hi - will this do the trick?
Hi @Anonymous ,
You want to get the date interval within the date range selected by slicer, right?
If so, please use:
Datediff=DATEDIFF( MIN ( 'Date'[Date] ), MAX ( 'Date'[Date] ), DAY))
Hi @Anonymous ,
You want to get the date interval within the date range selected by slicer, right?
If so, please use:
Datediff=DATEDIFF( MIN ( 'Date'[Date] ), MAX ( 'Date'[Date] ), DAY))
Hi - will this do the trick?
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |