How to sum by month in one column then by week in others

[Thedatadude]

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, 

[camargos88 · Accepted solution]

Hi @Thedatadude ,

I hope it helps you.

Download PBIX 

Att,

Ricardo