Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am creating a dashboard for absence reporting last week I had help from this community to create the following dax
Solved! Go to Solution.
Hi Try this,
rolling 6 months =
CALCULATE(COUNT(Absence[Start Date]),DATESINPERIOD(Absence[Start Date],today(),-6,MONTH))
and after on the filter panel you fix the value at >3 for this measure
Tried it just comes up with blank table
Hi Try this,
rolling 6 months =
CALCULATE(COUNT(Absence[Start Date]),DATESINPERIOD(Absence[Start Date],today(),-6,MONTH))
and after on the filter panel you fix the value at >3 for this measure
Thanks this works
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
9 |
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |