Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
2 years ago

Highlight missing dates using DAX

Hi All,

I have a requirement to highlight a date if it is blank. Data is available in two tables.


Please find sample data below:
Table1:

ProtocolStatus
19In-Progres
20Activated
21Closed
22Open


Table2:

ProtocolRDate
1906/12/2023
2005/05/2021
21 


Requirement : If the date is blank , then show as 1 else 0.
I created a column in Table 2 as

 

 

BlankValues = 
IF(ISBLANK('Table (2)'[RDate]),1,0)

 

 

When , I use this column with Table1, there is no value for a protocol if it is not available in Table2.

ProtocolBlank Values
190
200
211
22 


Please find sample pbix file in the link below:
https://drive.google.com/file/d/17ZFDxOfCDedtMN9vJxl17R06r-WauDP7/view?usp=sharing
Thank you

Need Help

1 Reply

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    2 years ago
    if you add this as a new measure this should bring back the required result
     
    Is Blank =
    var result = SUM('Table (2)'[BlankValues]) +0
    return  if(result =1,0,1)