Forum Discussion
chotu27
Post Patron
Post PatronGet 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
chotu27Post Patron
Post PatronTomMartens Got it Worked but still it is not showing correct previous values please check attached Pbix
TomMartens
Super User
Super UserHey,
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