Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
5 years ago
Solved

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 =
ADDCOLUMNS (
CROSSJOIN(
CALENDAR(MIN(Tabel1[DateIn]), MAX(Tabel1[DateOut])),
UNION (
ROW ( "Section", VALUE("A" )),
ROW ( "Section", VALUE("B" ))
)))
 
Hopefully someone can help me.
Need Help
  • icturion's avatar
    icturion
    5 years ago

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

1 Reply

  • icturion's avatar
    icturion
    Icon for Resolver II rankResolver II
    5 years ago

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