Forum Discussion

pasupathi's avatar
pasupathi
Icon for Helper I rankHelper I
4 years ago
Solved

write the dax logic for all the projects

Dear Helper, ProjectName     Endate A                       10/06/2022 B                        15/06/2022 C                        22/07/2022 D                        11/08/2022 E             ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi pasupathi ,

     

    You could create a measure as below and use it for conditional formatting:-

    Measure 2 =
IF (
    MAX ( 'Table (3)'[End date] ) >= DATE ( 2022, 06, 06 )
        && MAX ( 'Table (3)'[End date] ) <= DATE ( 2022, 09, 06 ),
    "YELLOW",
    "RED"
)

    Output:-

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi pasupathi ,

 

You could create a measure as below and use it for conditional formatting:-

Measure 2 =
IF (
    MAX ( 'Table (3)'[End date] ) >= DATE ( 2022, 06, 06 )
        && MAX ( 'Table (3)'[End date] ) <= DATE ( 2022, 09, 06 ),
    "YELLOW",
    "RED"
)

Output:-