The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |