Daily/MTD/YTD Sales in one column

[Anonymous]

Hi,

I need to display Daily Sales , MTD Sales and YTD Sales in one column as shown below. I have used the DAX MTD, YTD functions but am not able to display as shown below in Power BI. 

Any suggestions ? Client is using Quick base and able to produce this report ( Note, Actual Gross $ is one column) 

Brand ($000s)	Period	Actual	Budget	% to Budget	Actual	Budget	% to Budget	As of Date
Gross	Gross	Gross	Net $	Net $	Net
$	$
ABC	Daily	0	0		0	0		11/9/2018
ABC	Month-To-Date	20,753	18,261	114%	10,671	9,934	107%	11/9/2018
ABC	Year-To-Date	734,263	701,000	105%	389,404	381,219	102%	11/9/2018
DEF	Daily	0	0		0	0		11/9/2018
DEF	Month-To-Date	20,642	18,649	111%	13,768	12,383	111%	11/9/2018
DEF	Year-To-Date	757,670	705,058	107%	504,070	469,314	107%	11/9/2018
GHI	Daily	0	0		0	0		11/9/2018
GHI	Month-To-Date	9,060	2,478	366%	1,101	657	168%	11/9/2018
GHI	Year-To-Date	464,318	333,140	139%	37,344	55,582	67%	11/9/2018
LMN	Daily	295	439	67%	246	375	65%	11/9/2018
LMN	Month-To-Date	3,913	3,534	111%	3,258	3,024	108%	11/9/2018
LMN	Year-To-Date	135,964	112,626	121%	114,335	95,956	119%	11/9/2018
OPQ	Daily	0	361	0%	0	272	0%	11/9/2018
OPQ	Month-To-Date	5,034	3,180	158%	3,725	2,390	156%	11/9/2018
OPQ	Year-To-Date	42,110	20,828	202%	30,983	14,351	216%	11/9/2018
RST	Daily	0	23	0%	0	2	0%	11/9/2018
RST	Month-To-Date	200	1,627	12%	53	137	39%	11/9/2018
RST	Year-To-Date	25,382	43,684	58%	8,635	7,411	117%	11/9/2018
WXY	Daily	0	0		0	0		11/9/2018
WXY	Month-To-Date	194	550	35%	41	155	27%	11/9/2018
WXY	Year-To-Date	29,970	30,119	100%	9,096	9,080	100%	11/9/2018

Sales table is standard with a calendar table marked as data table. 

Any help is appreciated - Power BI gurus ??

Regards

SK