Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, how can I add lap number column in PowerQuery or in Dax? Tour number is based on store, date, area.
I am attaching an example of what I would like to overe in the column N Lap
Thx
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
N Lap CC =
RANKX (
SUMMARIZE (
FILTER ( 'Table', 'Table'[Store] = EARLIER ( 'Table'[Store] ) ),
'Table'[Date]
),
'Table'[Date],
,
ASC
)
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,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a new column.
N Lap CC =
RANKX (
SUMMARIZE (
FILTER ( 'Table', 'Table'[Store] = EARLIER ( 'Table'[Store] ) ),
'Table'[Date]
),
'Table'[Date],
,
ASC
)
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.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
37 | |
21 |