I have this report, just for people to choose what they want to see, you know? After choosing the company, Cost center, year, month, etc my card, which sows the last transaction date shows the incorrect date.
I think the measure should be something like this:
Last Transaction Date = CALCULATE ( MAX ( Dates[Date] ), FILTER ( 'Main Data', 'Main Data'[Type] = "Actual" ), ALL ( Dates ) )
I guess, despite this measure doesn’t give me an error, it shows wrong answer. So, i guess there’s a rule somewhere that i don’t know.
Could you please explain the rule to me cose i think i do it everytime backwards.
Thank you very much