Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
icturion
Resolver II
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:

icturion_0-1614789140981.png

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.
1 ACCEPTED SOLUTION
icturion
Resolver II
Resolver II

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

View solution in original post

1 REPLY 1
icturion
Resolver II
Resolver II

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.