Good morning, I can’t find a solution to this problem. I have this calculation:
and everything is fine up to that point. The issue arises when I try to add a column that subtracts the current month from the previous month, as shown in the image.
I have tried all table calculations, but I believe the problem is due to aggregations. I hope you can help me.
Thank you.
Hello @SolSar62 hope this message finds you well!!
have you ever tried the difference formula? when I saw you problem, looks like this could be a way:
Calculates difference of the measure with forward or backward lookup partitioned and sorted by specified attributes.
difference(aggregated measure, [sort attribute ASC/DESC, ...], lookup index, [partition by attribute, ...])
please, tell me if it’s work for you
Yes, it worked, Thanks! I had to add a filter that considers both the current and the previous date.
I ended up with one column showing the correct calculation and another one that is empty.
When I try to hide the empty column, all the results disappear.
can you flag this as a solution? help me to grow in the community
