Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, i have a table with many variables and it have duplicates, what i want to do is to have count for the variable when it appear the first time and does not count the variable when is appear the second time onwards.
Var | Var | Count | |
A | A | 1 | |
A | A | null | |
B | B | 1 | |
B | B | null | |
C | C | 1 | |
D | D | 1 |
Solved! Go to Solution.
Hi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:
2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Yqy
You can achieve it with 2steps :
1 . In PQ add the index column:
2. In the Data editor add a column with this Dax:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi, is it possible to do the second step in Query using M language instead of in the data editor using DAX
Hi again,
Yes, it is possible please follow these few steps (after adding index column):
1. Group by with counting all rows:
2. Expand only index
3. Add a conditional column
4. remove unnecessary columns
RESULT :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks for the help, your solution works.
I was happy to help 😊
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
87 | |
66 | |
51 | |
45 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |