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
    2 years ago

    Thanks all. 
    Only way i could solve it was to do a left join (merge) in power query using the caledar table as the base. 

databot_kd's avatar
databot_kd
Helper III
2 years ago

Hi ced_f ,

I tried your solution but still not getting the expected results...

 

ced_f's avatar
ced_f
Frequent Visitor
2 years ago

Hi databot_kd ,

Not sure to understand what you are trying to achieve. The symbol you want to calculate is for Dimension or Fact table ? 

the lines for which you don't have the symbol mean that these dates from Calendar table (Dimension) don't have a matching row in Fact table. so it's logic to get an empty symbol as symbol is calculate from Fact table. 

  • databot_kd's avatar
    databot_kd
    Helper III
    2 years ago

    ced_f 

    I just trying to flag two things:
    1. If it is a weekday and there is no transaction date then Icon1
    2. If it is a weekend then Icon2

    My calendar table has the date in the first column and the weekday_type 
    My transactions has the ref_date which is linked to the Calendar.date 

    Would it be possible to replace empty then based on a condition?

     

    • 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