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?
Solved! Go to Solution.
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.