Let's say I have selected month 01/03/2021 and Div is not selected I would always like to show latest Value for Acct. If for that period value is not available, need to go back to previous periods to select latest available Value. I am using below measure which is working fine in this case
Now, when I selectmonth 01/03/2021 and Div = 'a' , for Acct =1, I would like to show value as 0, because for this Acct, latest Date has Div=b. Similarly, for Acct=2, I would like to show value as 70, because for this Acct, latest Date has Div=a
In short, when I select any Div, particular Acct should only get value if that Acct's latest Date has that selected Div.
Similarly, when I selectmonth 01/03/2021 and Div = 'b' , I should get below
I am not able to get around the expression when particular Div is selected