Forum Discussion

skitzo's avatar
skitzo
Frequent Visitor
9 years ago
Solved

Solving a date puzzle!

I have 2 tables in PowerBI, "Calendar dim" and "Fact general ledger". I would like to filter the "Fact general ledger" table with a slicer which uses dates from "Calendar dim" table in a way that whe...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Try YEAR(MAX(CalendarTable[Date])) 

FilippoV's avatar
FilippoV
Helper I
9 years ago

I'm according with Anonymous, but i use this measure:

QtyFact =
VAR MinDate = MIN('CalendarDate'[Date])
VAR MaxDate = MAX('CalendarDate'[Date])
RETURN CALCULATE(SUM('Fact'[Amount]);INTERSECT(VALUES('Fact'[DocumentDate]);DATESBETWEEN('Fact'[DocumentDate]);MinDate;MaxDate)))

 

QtyExp =
VAR MinDate = MIN('CalendarDate'[Date])
VAR MaxDate = MAX('CalendarDate'[Date])
RETURN CALCULATE(SUM('Exp'[Amount]);INTERSECT(VALUES('Exp'[DocumentDate]);DATESBETWEEN('Exp'[DocumentDate]);MinDate;MaxDate)))