How to add dates to existing data in a table

[Jarodp42]

Hi everyone, I am trying to add the date range 1/1/2019 - 12/31/2019 to my data. Can someone please help me understand how to accomplish this?

Example data:

Name	value
A	10
B	15
C	20

I am looking to add a date range for each row on my table like this.

Name	Value	Date
A	10	1/1/2019
A	10	1/2/2019
A	10	1/3/2019
A	10	1/4/2019
A	10	1/5/2019
A	10	1/6/2019
A	10	1/7/2019
A	10	1/8/2019
A	10	1/9/2019
A	10	1/10/2019
A	10	1/11/2019
A	10	1/12/2019
B	15	1/1/2019
B	15	1/2/2019
B	15	1/3/2019
B	15	1/4/2019
B	15	1/5/2019
B	15	1/6/2019
B	15	1/7/2019
B	15	1/8/2019
B	15	1/9/2019
B	15	1/10/2019
B	15	1/11/2019
B	15	1/12/2019
C	20	1/1/2019
C	20	1/2/2019
C	20	1/3/2019
C	20	1/4/2019
C	20	1/5/2019
C	20	1/6/2019
C	20	1/7/2019
C	20	1/8/2019
C	20	1/9/2019
C	20	1/10/2019
C	20	1/11/2019
C	20	1/12/2019

Can someone please explain to me how I can accomplish this, as I am fairly new to Power BI and still learning the ins and outs of the system. Thanks!

[parry2k]

@Jarodp42 so you want full year apply to these 3 rows.

[parry2k · Accepted solution]

@Jarodp42 assuming your original table name is Table, go to modelling tab and add following expressoin to create new table and this new table will have what you are looking for

New Table = 
VAR __calendar = CALENDAR ( "2019,1,1", "2019,12,31" )
RETURN CROSSJOIN ( __calendar, 'Table' )

[Jarodp42]

@parry2k Yes, that is exactly what I was looking for. Thank you for the help!!!