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.
Quick question,
I have source data in the following format:
StoreNumber | Transdate | NetComp | NetSales | InternetNetSales | TotalOrders | Discounts |
100 | 1/24/2017 0:00 | 0.00 | 1000.58 | 200.32 | 131 | 100.66 |
100 | 1/25/2017 0:00 | 0.00 | 1500.76 | 253.15 | 118 | 10068 |
100 | 1/26/2017 0:00 | 0.00 | 2500.43 | 250.54 | 109 | 120.12 |
100 | 1/27/2017 0:00 | 0.00 | 7000.83 | 700.25 | 259 | 250.72 |
100 | 1/28/2017 0:00 | 0.00 | 7500.62 | 900.33 | 248 | 250.1 |
100 | 1/29/2017 0:00 | 0.00 | 5000.23 | 630.79 | 174 | 200.63 |
100 | 1/30/2017 0:00 | 0.00 | 2400.40 | 250.76 | 100 | 170.73 |
100 | 1/31/2017 0:00 | 0.00 | 2,489.22 | 322.17 | 122 | 90.38 |
100 | 2/1/2017 0:00 | 0.00 | 3,907.32 | 393.55 | 134 | 250.12 |
100 | 2/2/2017 0:00 | 0.00 | 3,326.48 | 214.02 | 155 | 150.69 |
I need to calculate some measures based on these and addition numbers (more columns not shown here). However, the desired display is in the format:
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |
Measure 1 | ### | ### | ### | ### | ### | ### |
Measure 2 | ### | ### | ### | ### | ### | ### |
Measure 3 | ### | ### | ### | ### | ### | ### |
Measure 4 | ### | ### | ### | ### | ### | ### |
I can create the measures easy enough and obviously get the weekday.
Do I have to wait for the planned idea, measures as rows, here:
Or does someone have a way that I might be able to accomplish this using some tricky pivoting/unpivoting/grouping of data in the query?
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |