Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to add one more columns, which would be equal to the RV line of each set of records.
Column1 Column2 Column3
A RV 100
A AB 80
A AB 30
B RV 200
B AB 120
B AB 70
Would expect:
Column1 Column2 Column3 Column4
A RV 100 100
A AB 80 100
A AB 30 100
B RV 200 200
B AB 120 200
B AB 70 200
Thanks a lot!
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
Column4 CC =
MAXX (
FILTER (
Data,
Data[Column1] = EARLIER ( Data[Column1] )
&& Data[Column2] = "RV"
),
Data[Column3]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
Column4 CC =
MAXX (
FILTER (
Data,
Data[Column1] = EARLIER ( Data[Column1] )
&& Data[Column2] = "RV"
),
Data[Column3]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks a lot!
@jiangxm80 , A new column in DAX
= MAxx(filter(Table, [Column1] = earlier([Column1]) , [Column3] )
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
User | Count |
---|---|
85 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |