Forum Discussion

matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago

DAX Calculating on Wrong Rows - Not Recognizing Join Relationship Properly

Hello, I'm trying to figure out why DAX isn't calculating properly on the right rows. I have this indicator made in DAX trying to show which accounts have different dates from previous and current da...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

matsahiro , You need to have a common account table and join these two tables with that. and analyze with the account numbers from the common table.

 

You can create a measure like

New_Date_Indicator = IF(max('Current'[Statement Date])=max(Previous[Previous Statement Date]),"0","1")

matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago

amitchandak I went ahead and created the common account table and added indexes to the other two tables. I joined on the indexes with ID in account table. Here's what the relationship looks like. 

The relationships looks to be right until I add in the indicator. 

 

  • matsahiro's avatar
    matsahiro
    Icon for Helper II rankHelper II
    5 years ago

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      matsahiro , Make these 1-1 Join as 1-M (account is 1), single direction and try 

      • matsahiro's avatar
        matsahiro
        Icon for Helper II rankHelper II
        5 years ago

        Unfortunately when I establish the relationships like that, the visual breaks even without the indicator included in the visual.