Forum Discussion

esuryahadi's avatar
esuryahadi
Icon for Helper I rankHelper I
2 years ago
Solved

Need Help DAX with Case

Hello, I have a table like this. ID Index Start Date Finish Date Days Status Alert 1 AW2 01/09/2023 16/11/2023 76 On Going   2 AD3 02/08/2023 16/10/2023 75 On Going   ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I think my understanding of the logic was wrong.

    I tried to fix it and please check the below picture and the attached pbix file if it suits your requirement.

     

     

esuryahadi's avatar
esuryahadi
Icon for Helper I rankHelper I
2 years ago

Thank you in advance and I apologize for any inconvenience. However, there are some discrepancies that need to be addressed. Specifically, ID 2 should be marked in red as it has exceeded the completion date. On the other hand, ID 3 should not remain in white, since its completion date is still far away.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I think my understanding of the logic was wrong.

I tried to fix it and please check the below picture and the attached pbix file if it suits your requirement.