Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi ,
Attached the data below, I want to remove the duplicates and have the desired output. All my data is from the same table.
Stack Order | Report No |
1 | 1110 |
1 | 1111 |
1 | 1112 |
1 | 1113 |
2 | 1110 |
2 | 1111 |
2 | 1112 |
2 | 1113 |
3 | 1110 |
3 | 1111 |
3 | 1112 |
3 | 1113 |
4 | 1110 |
4 | 1111 |
4 | 1112 |
4 | 1113 |
5 | 1109 |
6 | 1109 |
7 | 1109 |
8 | 1109 |
9 | 1109 |
10 | 1107 |
11 | 1107 |
12 | 1107 |
13 | 1107 |
14 | 1106 |
14 | 1108 |
15 | 1105 |
16 | 1104 |
17 | 1103 |
18 | 1103 |
19 | 1103 |
20 | 1103 |
21 | 1106 |
21 | 1108 |
Desired Output after filters or dax being applied :
1 | 1110 |
2 | 1110 |
3 | 1110 |
4 | 1110 |
Thank you in advance.
Solved! Go to Solution.
Please try the following DAX:
SummaryTable = ADDCOLUMN(VALUES(Table[Stack Order]), "First Report No", CALCULATE(MIN(Table[Report No])))
But the same result can also be acheived in PowerQuery, where you can go to Transform > Group By, and group by the Stack Order and Aggregate by the min Report Number
Please try the following DAX:
SummaryTable = ADDCOLUMN(VALUES(Table[Stack Order]), "First Report No", CALCULATE(MIN(Table[Report No])))
But the same result can also be acheived in PowerQuery, where you can go to Transform > Group By, and group by the Stack Order and Aggregate by the min Report Number
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |