Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Question about concept: Each row of my table represents quantity = 1, create a custom column "Quantity = 1" is correct? If I don't do this, there is no way to go forward.
Tks
Solved! Go to Solution.
Hi @Anonymous, yes you can add custom columns such as this. It can be done easily in the Query Editor or in DAX.
This can be useful to SUM to get numbers that represent Counts.
You can also do this using calculated measures using the COUNTROWS function, but it depends on how confident you are with creating DAX measures. If you have a particular issue you are trying to solve, post more about it here and we will do our best to help you.
Hi @Anonymous, yes you can add custom columns such as this. It can be done easily in the Query Editor or in DAX.
This can be useful to SUM to get numbers that represent Counts.
You can also do this using calculated measures using the COUNTROWS function, but it depends on how confident you are with creating DAX measures. If you have a particular issue you are trying to solve, post more about it here and we will do our best to help you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |