Creating Data Tables with Dates and several records for one date

[pszczulka1984]

Hi Guys,

I have created a table with dates as per script below now I need to have each of the days listed lets say 5 times for each day with each date having channel A, B, C, D, E. How can I add this as at the minute each date shows only 1's and I didnt add the records yet, not sure how to achieve that.

 I will be very greatful for your support 🙂

ADDCOLUMNS (

    CALENDAR ( DATE ( 2019, 3, 1 ), DATE ( 2024, 2, 28 ) ),

    "Day", FORMAT ( [Date], "DDDD" ),

    "DayNum", WEEKDAY ( [Date], 2 ),

    "StartMonth",EOMONTH( [Date],-1)+1,

    "EndMonth",EOMONTH([Date],0),

    "MonthtStartDate&Weekday",EOMONTH( [Date],-1)+1&FORMAT ( [Date], "DDDD" )

Thank you,

Joanna

[amitchandak]

@pszczulka1984 , Not very clear , You can have time table

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

Join date with date and time with time

Time = [date time].time

date =[date time].date

[pszczulka1984]

Hello,

1st of all thank you very much for taking time to read my post.

What I am trying to achieve is as per table below. So each date will appear as many times as many channels I have.

Date	Channel
1/01/2020	A
1/01/2020	B
1/01/2020	C
2/01/2020	A
2/01/2020	B
2/01/2020	C
3/01/2020	A
3/01/2020	B
3/01/2020	C

Thank you in advance,

[amitchandak · Accepted solution]

@pszczulka1984 , See if this can help

crossjoin

new table = crossjoin([Date],[Channel])

https://docs.microsoft.com/en-us/dax/crossjoin-function-dax