Forum Discussion
Get Previous record
Hi All, I wanted to find previous record in matrix visual based on hierachy displayed below. Any Help with DAX please help me
TomMartens Got it Worked but still it is not showing correct previous values please check attached Pbix
Hey,
it's quite difficult to provide another solution. My example works with the data you provided, please explain what you expect, and show all the data.
You have to be aware that data will be aggregated,, this is the reason why I choose the aggregate function AVERAGE, but maybe you have to choose SUM.
Regards
Tom