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

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.