Hi,
How to Calculate Duedate greater than Current date and Compare Status is For Solidation , if the conditon is true "Beyond SLA" false "SLA", See below Screen shot
I tried
SLAStatus = SWITCH( TRUE(),VALUE(TODAY() >'sheet1'[DueDate])) && if(sheet1[Staus] == "For Solidation"), "BeyondSLA","SLA")
but I/m getting Error, can you please help me to solve this issue?
1 ACCEPTED SOLUTION
@Anonymous
Create a calculated column.
SLAStatus = IF(MyTable[Duedate]>TODAY() && MyTable[Status]="For Solidation","Beyond SLA","SLA")
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Regards,
Nandu Krishna
@Anonymous
Create a calculated column.
SLAStatus = IF(MyTable[Duedate]>TODAY() && MyTable[Status]="For Solidation","Beyond SLA","SLA")
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Regards,
Nandu Krishna
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
