Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Looking for some inspiration please.
Within a Dataflow Query I want to group by NAME & Type and for the DATE column replace this with a list which in this example would hold two dates.
What I am trying to do is find where there are records missing (by Date) so I want to use the List.Differance to find these against a list of know dates so looking for a way to make the list for each distinct Name & Type combination.
Name | Type | DATE |
A | 1 | 01/01/2020 |
A | 1 | 08/01/2020 |
A | 2 | 01/01/2020 |
A | 2 | 08/01/2020 |
B | 1 | 01/01/2020 |
NAME | Type | Date |
A | 1 | list (01/01/2020, 08/01/2020) |
A | 2 | list (01/01/2020, 08/01/2020) |
B | 1 | list (01/01/2020) |
Thanks in advance.
Solved! Go to Solution.
OK -- figured it out
#"FTG Step 2: List Dates" = Table.Group(#"FTG Step 2: Make table unique",{"Name", "Type", },{"ActualDates" , each [#"Report Date - TEXT"] ,type list})
This gives you a list in each row.
Note: It needs to be a Text value so you can expand it later
OK -- figured it out
#"FTG Step 2: List Dates" = Table.Group(#"FTG Step 2: Make table unique",{"Name", "Type", },{"ActualDates" , each [#"Report Date - TEXT"] ,type list})
This gives you a list in each row.
Note: It needs to be a Text value so you can expand it later
@Anonymous ,
No very clear. Refer if this can help
https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
Hi,
No concatenatex works across a row what I am looking to do is group a number of rows together like you would with Group By but instead of aggregating i want to create a list of these values.
It is also like pivoting but I don't want to create new columns I want a list of these values.
Regards
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |