Indicator not working - Dax not referencing right values?

[matsahiro]

Hello, I have this simple indicator created. Basically if the current statement date is different from the previous statement date by account name, then return 1. If not, return 0. For some reason, it's not returning properly at all. 

Joined by "Account" field. I tried making an Account reference table as well, but that did not seem to do the trick.

[amitchandak · Accepted solution]

@matsahiro , Create a common account table, join both with that with 1-M creation.

Or merge these table in power query and then try

refer: https://www.youtube.com/watch?v=Bkf35Roman8

[matsahiro]

The merging of the table in power query definitely works. Thank you.