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 all,
My requirment is I have to show the next 7,14,21 days from today which are in Due_dates column and whoes status are "Open"
7days and 14 dasys and 21 days shoul come in Slicer .
I have ID_Column, Due_Date,Status_Colum.
If i refresh the data today my report should show next 7days data or 14 days or 21 days data based on the filter selected .
Solved! Go to Solution.
Hi @Anonymous ,
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , See if this can work, you can create a new measure with 14 and 21 days in the same manner
Measure 7 day=
var _min = today()
var _max = today() +7
return
calculate(count(Table[ID]), filter(table,table[status]="Open" && table[Due_dates]>=_Min && table[Due_dates]<=_max))
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |