TRICKY - Previous Value

[Anonymous]

Hi Expert

I am having a nightmare trying to calculate the previous value DAX Formula as a calculated column. My over data set have over 1 million rows of data.

The below is a small sub set of the data. i want to be able to calculate the previous value based on the condition as per my sample data. I have show the expected results in the previos value column..

Terms	Brand	Index	Product	Date	Value	M Column	Period	Percentage	Pay Down Balance	Previous Value
BTMT Fee	Apple	277	0% for 9	Jan-21	475	M0	109	95%	451	0
BTMT Fee	Apple	277	0% for 9	Jan-21	475	M1	109	100%	475	475
BTMT Fee	Apple	278	0% for 9	Feb-21	202	M0	110	95%	192	202
BTMT Fee	Apple	278	0% for 9	Feb-21	202	M1	110	100%	202	0

[v-henryk-mstf]

Hi @Anonymous ,

According to the data model you provided, I cannot understand the calculation logic of the Previous Value field. Can you clarify it in detail and your specific needs so that I can answer it for you as soon as possible.

Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.