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