Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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                 ...
DAX
POWER BI Dax rules
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

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 🙂