Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have Phonelog table that have DateofRecord as a column
I use DateofRecord in Slicer. what I want to get is when user choose As of Date in the last 20(or N number of days). I like to display 20 (or N number of days) in the card. see attached picture.
How to accomplish this?
thanks
Solved! Go to Solution.
thank you Lin, this works. thank you for your quick reply!
hi, @kristydanda
If "As of Date" is a field of calendar table?
If so, you could create a measure
number of days be choosed = CALCULATE(COUNTA('calendar'[As of Date]))
then drag it into a card visual.
If not, you could create a calendar table, then create a relationship with As of Date,
then create a measure like below:
number of days be choosed = CALCULATE(COUNTA('calendar'[Date]))
Then drag the field of date from calendar table into slicer and the measure into card visual.
Best Regards,
Lin
thank you Lin, this works. thank you for your quick reply!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |