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.
Hi, While combining two records into one. I used "Text.Combine". This worked and now my question is how to get the count of records which were used for merging into a single record.
Quoting the example below
Existing:
Column1 . Column2
------------------------
1000 abc
1000 xyz, lmn
post combine
Column1 . Column2
------------------------
1000 abc, xyz, lmn
Now.. need to understand how many records were there before merging into one using DAX
Regards
@Anonymous wrote:Hi, While combining two records into one. I used "Text.Combine". This worked and now my question is how to get the count of records which were used for merging into a single record.
Quoting the example below
Existing:
Column1 . Column2
------------------------
1000 abc
1000 xyz, lmn
post combine
Column1 . Column2
------------------------
1000 abc, xyz, lmn
Now.. need to understand how many records were there before merging into one using DAX
Regards
Found the solution
1. Select the column and point your mouse point on (...) and select "New Quick Measure"
2. In the popup window, select the listbox on the left and look for "Concatenated List of Values" in "Text" header
.. it should work
If you want to sum/difference ... on column1.. then
1) use the same step
2) Under "Mathematical Operations" select "Addition"
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |