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.
Anonymous I guess this is not how your raw data looks like, solution can be very different based on how your data is shaped, so share sample data the way you have it in your mode and then we can provide a solution.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Hi parry2k ,
Of course!
I made a sample set of two columns > Month and year and Customers.
The link is as follows:
https://drive.google.com/file/d/11gz9gMfT2QmjezEj6ExlPBpBlUFg_y_5/view?usp=sharing
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 ZhiIf 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%