cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Resolver II

## DAX calendar table with extra columns

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 =
CROSSJOIN(
CALENDAR(MIN(Tabel1[DateIn]), MAX(Tabel1[DateOut])),
UNION (
ROW ( "Section", VALUE("A" )),
ROW ( "Section", VALUE("B" ))
)))

Hopefully someone can help me.
1 ACCEPTED SOLUTION
Resolver II

Hello,

Tabel =
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]))
)
Resolver II

Hello,

Tabel =
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]))
)

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors