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.
Hi All!
I have data that looks like this
fullname | we_date | BILLING1 | BILLING2 | BILLING3 |
Theo Von | 2/16/2020 | NULL | NULL | 2746.78 |
Theo Von | 3/1/2020 | NULL | NULL | 2785.22 |
Theo Von | 2/23/2020 | 10 | NULL | 1407.25 |
Theo Von | 2/9/2020 | 10 | 0 | 5440.56 |
Theo Von | 1/5/2020 | NULL | NULL | 3314.62 |
Theo Von | 3/8/2020 | NULL | NULL | 2906.56 |
Theo Von | 1/12/2020 | 16500 | 0 | 5710.24 |
Theo Von | 3/15/2020 | NULL | NULL | 3285.4 |
Theo Von | 1/26/2020 | NULL | NULL | 2690.58 |
Theo Von | 2/2/2020 | NULL | NULL | 3484.2 |
Theo Von | 1/19/2020 | NULL | NULL | 3193.98 |
Theo Von | 3/22/2020 | NULL | NULL | NULL |
I'm trying to display a matrix or table that will have a monthly running total of Billing 1 by the current week ending date. Then just the row level week ending date value for Billing 2 and Billing 3 so if was running it for week ending 2/23 it would display like this with Billing 1 as the total for 2/1-2/23 for that column then just the 2/23 week ending date values for billing 2 and billing 3.
Fullname | Billing1 | Billing2 | Billing 3 |
Theo Von | 20 | 0 | 1407.25 |
Anyone have any ideas on a place to begin with this?
Cheers,
Solved! Go to Solution.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |