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.
I'm trying to get the number of days to calculate the average over a period of time selected by a slicer.
Let's say i select Last week in the slicer, then i want the number to be 7 days and then i can use that to calculate.
if i chose last month it should return the number of days in the last month and so on..
But i cant seem to get a "constant" value from my datetable.
this is how i create my date table
DateTable = CALENDARAUTO()
I've tried firsdate/lastdate datediff
allselected
datesbetween
counting rows..
it's probably a simple fix but i cant seem to figure this one out
HI @ppz,
>>Let's say i select Last week in the slicer, then i want the number to be 7 days and then i can use that to calculate.
if i chose last month it should return the number of days in the last month and so on.
Maybe you can try to add a calculated column to calendar table to mark data range, then use this column as the source of slicer. After these steps, you can get the range count based on slicer.
In addition, you can also take a look at below article about use two slicers to filter on different date unit.
Calculate Dynamic Rolloing Total Based on Slicer
BTW, current power bi not support to analysis specific date range based on text, you need to manually build a mapping table to achieve these operation.
Regards
Xiaoxin Sheng
Hi @v-shex-msft , could you please explain what kind of calculated column you should add to the Calendar Table?
My slicer is associated to the "CurrentDay" date in my Calendar table.
Then I added this column:
TotDays = calculate(count('Calendar'[CurrentDay]))
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |