Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Measure for blank values

Hi all,   Urgent help !! I am writing a dax measure for a matrix table so the table has month in columns and Items in row will share the screenshot below for reference. I have a slicer for year & f...
Need Help
Show and Tell
Tips and Tricks
achanikya's avatar
achanikya
Helper I
3 years ago

Anonymous 

try 

 

IF(
OR(
Max(Month index) > Month(now) && Max(Year) = year(now),
AND(Max(Month index) = 2, Max(Year) = 2023)
),
IF(ISBLANK(SUM(MatrixTable[Value])), BLANK(), "Sky Blue"),
"Light Green"
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    thankyou for the help but it's not working I have been trying to get blank values of the rest of the months as blue but it is showing green only since it's failing the condition