Forum Discussion

databot_kd's avatar
databot_kd
Helper III
2 years ago
Solved

IF condition across multiple tables returns blank/null values

Hi community,  please can you assist. I am trying to create a simple DAX if statement across two table linked.  Data model setup: Table1 - Calendar table  Table2 - Transaction table  Table...
Need Help
databot_kd's avatar
databot_kd
Helper III
2 years ago

the reason why i can see the blanks is cause i selected 'Show Items with No Data" 

ced_f's avatar
ced_f
Frequent Visitor
2 years ago

Hi databot_kd ,

Can you try with something like this : 

 

Icon = VAR _weekday_type =
    SELECTEDVALUE ( 'Date'[weekday_type] )
RETURN
    IF (
        _weekday_type = "Weekend",
        "symbol1",
        IF (
            _weekday_type = "Weekday"
                && ISBLANK ( COUNT ( 'Transaction'[ref date] ) ),
            "symbol2",
            BLANK ()
        )
    )

but I don't understand well what you are trying to achieve. If i understand well, the icon2 is fill only if you don't have transactions dates on it ? is'nt it ? 

 

Regards