Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello alll,
I am trying to create a slicer that filters reports by 90 days, past due, due soon. How do I write the conditions below in Dax
if due date is over 90 days ="past due"
If due date is between 45 to 90 days = "Due soon"
If due day i equal to 90 days then = "90 days"
Than you
SWITCH(TRUE(),
[Due Date]>90,"past due",
[Due Date]=90,"90 days",
[Due Date]>44,"due soon",
"not due soon")
If(
Due Date > 90,
"Past due",
If(Due Date = 90,
"90 days",
If(Due Date = 45 && Due Date < 90,
"Due soon",
)
)
)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |