Power BI Community Blog
3 MIN READ

Iteration in DAX

DavisBI's avatar
DavisBI
Solution Specialist
6 years ago
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 calculat...
Updated 6 years ago
Version 10.0
DAX
Power BI Challenge
DavisBI's avatar
Solution Specialist
Joined April 07, 2020
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
CongPham's avatar
CongPham
Helper I
6 years ago

Many thanks for your post DavisBI 

 

I am having a similar problem at the moment. Can you have take a look and give me the solution?

 

I have a table with column "Source Value" and want to get value on "Target Value". The problem is the value on "Target Value", from row 2, base on "Source Value" and "Targer Value" itself.

 

So, any DAX or Power Query can reslove my problem? (Please see the picture below)