In practical business, data iteration is widely used, such as present value or depreciation. However, as we all know, DAX is a functional language based on column engine, each row of data is calculated based on its own row context. But sometimes ...

I really enjoyed recently working through the latest Power BI Challenge from Enterprise DNA. This was not an easy scenario that we were dealing with. We had some HR consultation data and the required analysis was quite unique.