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.
Solved! Go to Solution.
@Hussain_R , Please paste the data in table format. Not able to understand the same
Based on what I got
Assume the current format is
Column 1 | Column 2 |
BillF | 1/1/2024 |
BillF | HDM24001 |
BillF | ABC Corp |
BillV | 234.7 |
... | ... |
Expected is
Bill Date | Bill Reference | Customer Name | Bill Value |
1/1/2024 | HDM24001 | ABC Corp | 234.7 |
... | ... | ... |
... |
Add an index column from 0
Add another column, divide by 4, Group Index
= Table.AddColumn(#"Previous Step", "Group Index", each Number.IntegerDivide([Index], 4))
Pivot the Table with the do not Aggregate option in Advance and try
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@Hussain_R , Please paste the data in table format. Not able to understand the same
Based on what I got
Assume the current format is
Column 1 | Column 2 |
BillF | 1/1/2024 |
BillF | HDM24001 |
BillF | ABC Corp |
BillV | 234.7 |
... | ... |
Expected is
Bill Date | Bill Reference | Customer Name | Bill Value |
1/1/2024 | HDM24001 | ABC Corp | 234.7 |
... | ... | ... |
... |
Add an index column from 0
Add another column, divide by 4, Group Index
= Table.AddColumn(#"Previous Step", "Group Index", each Number.IntegerDivide([Index], 4))
Pivot the Table with the do not Aggregate option in Advance and try
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |