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.
I have the following table structure:
My columns are SignUps, VerifiedReg, FTDs, FTWs, FTDConv%, Actives, ActiveFunders, DepositCount, DepositAmount, BetCount, CashTurnover, CashWagered, GGR, Hold%, FreeBetPayout, NGR, FreeBetStake, FreeBetStakeIssued, FreeBetStakeExpired, FreeBetActives, AvgTurnoverActives, AvgDepositAmt, AvgBetAmt, AvgFTDAmt, Avg1stBetAmt, FTWTurnover
And I want to pivot WeekNumber so that these values become all the column headers left to right.
I've drawn this up in excel of how it might look, with dummy values.
I've seen other posts where there are huge LET SOURCE = statements (that I would have no idea how to implement myself unfortunately).
Is there an easier way to do this? Or can anyone help with the LET SOURCE = solution?
Solved! Go to Solution.
Amazing thanks! Just 1 button click and I've spent a full day on this beforehand!
Watch this tutorial from 2:55
Create Table similar to Pivot in PowerBI | switch Column headers to rows | MI Tutorials - YouTube
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |