Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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",
)
)
)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 9 | |
| 7 | |
| 5 | |
| 5 |