Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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",
)
)
)
Check out the July 2025 Power BI update to learn about new features.