Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Name | Id | Count |
John | 1 | 2 |
Bob | 1 | 2 |
John | 2 | 3 |
Frank | 2 | 3 |
Joe | 2 | 3 |
How can I add a column that count the numer of IDs. I don't want to use measure or group by. If I create a measure, the counts are wrong when I use the names in the report.
TIA
Solved! Go to Solution.
Can't seem to get it to work; I've found an alternative solution. Thanks you.
Do I need to replace PriorStepName? It said PriorStepName wasn't recognize. I replaced it with an actual prior step name, also doesn't work.
It works on my side.
Here is the query...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFPSUTJUitWJVnLKT4KzoRJGYI5bUWJeNpznlZ8KYccCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Id = _t]),
#"Added Custom" = Table.AddColumn(Source, "Count", each let x=[Id] in List.Count(List.Select(Source[Id], each _ = x ) ) )
in
#"Added Custom"
Result:
Can't seem to get it to work; I've found an alternative solution. Thanks you.
You can add this step.
= Table.AddColumn(Source, "Count", each let x=[Id] in List.Count(List.Select( PriorStepName[Id], each _ = x ) ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.