Forum Discussion
Resolver IIMeasure that dynamically calculates average cost (avoiding circular dependency)
Community ChampionHi leolapa_br DAX is "specific" for row by row calculation, when we compare it with Excel. To perform some "standard" calculation in Excel to implement and leverage in DAX a lot of steps should be performed, this is my experience. I suggest you to analyse if work could be dan column by column approach in DAX, this should be base to implement Excel best practice how to deal with your scenario.
- leolapa_br
Thanks foy your valuable input some_bih.
I also posted the same question on Stack Overflow forum and an user also suggested the same approach you're suggesting by using calculated columns to do some prior calculations before getting to the point of writing the measure code.
She even went as far as providing the code for the required columns but I still ran into circular dependency while trying to implement her approach. I notified her of the issue and let's see if she'll reply with some fix.
