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