DAX calendar table with extra columns

[icturion]

Hello,

I'm trying to create a table in Power BI using the calendar function. Thing is that for every date i need two rows for section A and B.

Her is example for what i need:

This is what i got so far but it's not working:

Date =

ADDCOLUMNS (

CROSSJOIN(

CALENDAR(MIN(Tabel1[DateIn]), MAX(Tabel1[DateOut])),

UNION (

ROW ( "Section", VALUE("A" )),

ROW ( "Section", VALUE("B" ))

)))

Hopefully someone can help me.

[icturion · Accepted solution]

Hello,

I allready found al solution:

Tabel =

ADDCOLUMNS(

CROSSJOIN( VALUES(Kalendar[Date]), VALUES(Tabel1[Product])),

"IN", CALCULATE(SUM(Tabel1[Work1]), FILTER(Tabel1, Tabel1[DateIn] = Kalendar[Date])),

"CHECK", CALCULATE(SUM(Tabel1[Work2]), FILTER(Tabel1, Tabel1[DateCheck] = Kalendar[Date])),

"OUT", CALCULATE(SUM(Tabel1[Work3]), FILTER(Tabel1, Tabel1[DateOut] = Kalendar[Date]))

)