Iterating/Looping DAX function

[Harsh]

Hello @Akshay_05,

Thank You for posting your query onto the Forum.

Well, this similar sort of query was asked onto the Forum just few days back by one of our member. I’m providing a link of that solution about how it was achieved. It also contains the working of my PBIX file which you can download it for your reference.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Note: In order to view the entire post, please click onto the link and not onto the “Expand/Collapse” button.

Thanks and Warm Regards,
Harsh

Savings upon saving

Implementing projects one after the other that realizes energy savings in a section of operations. So if normal energy consumption for the operation is 200 000 GJ as an example. Should project 1 be implemented realizing a 10% saving then the energy after saving would be: 200000 * (1-0.1) = 200 000 * .9 = 180 000 GJ If we then implement project 2 and it realizes another 10 % saving the saving would be on 180 000 GJ and not 200 000 GJ. If we, therefore, implement 3 projects then the energy cons…