Forum Discussion
How to convert this sql query to DAX
How to convert this sql query to DAX in a measure Select value from KPI A where period in ( select B.period from Time B join period C on B.period=c.Period where b.quater >= c.quater-...
DAX measure:
Selected Value =
VAR CurrentQuarter = MAX('Period'[Quarter])
VAR FilteredPeriods =
FILTER(
ALL('Time'),
'Time'[Quarter] >= CurrentQuarter - 5 &&
'Time'[Quarter] <= CurrentQuarter - 1
)
RETURN
CALCULATE(
MAX('KPI A'[Value]),
'KPI A'[Period] IN DISTINCT(SELECTCOLUMNS(FilteredPeriods, "Period", 'Time'[Period]))
)
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
