DAX for filtering data up to given Year in Power BI Report: Create MaxDateKey measure in FactFinancial table using below DAX MaxDateKey = CALCULATE(MAX('Date'[DateKey]), ALLEXCEPT('Date', 'Date'[FYYear])) Revenue = CALCULATE(sum(FactFinancial[Amount] ),DimAccount[AccountType] = "Income", FILTER(DimDate, DimDate[DateKey] <= [MaxDateKey] )) All other measure like QoQ and Total Amount you apply below logic Revenue = CALCULATE(sum(FactFinancial[Amount] ),DimAccount[AccountType] = "Income", FILTER(DimDate, DimDate[FYYear] = max('Date'[FYYear]) )
Posts
Showing posts from August, 2017