Forum Discussion
Calculate change with dynamic dates
Hi Anonymous ,
You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Yes, I saw your sample, but in your sample, which part is max date? Which part is min date? If possible, could you please inform me in details? By the way, you also could rfere to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dax ,
Thank you for your reply.
The max and min date should be dynamic.
For example, by default, the min dat is January, 2018 and the max date is April 2020. If you add a date slicer, and you select only Janary and February 2020, than those two months are the min and max date.
So, by default, the result should be (6742-6085)/6085=10,8%
And for Jan en Feb 2020, it should be (6395-6345)/6345=0,8%
Hi Anonymous ,
You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Thank you! This was exactly what I was looking for.