Forum Discussion
Power BI Date calculation
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?
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 🙂
1 Reply
- nandukrishnavs
Community Champion
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 🙂