Forum Discussion

databot_kd's avatar
databot_kd
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper 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.