Forum Discussion

pavithrarajan's avatar
pavithrarajan
Frequent Visitor
1 year ago

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-...
Need Help
Kaviraj11's avatar
Kaviraj11
Solution Sage
1 year ago

Try this -

Measure = 
CALCULATE(
    SUM('KPI A'[value]),
    FILTER(
        'KPI A',
        'KPI A'[period] IN 
        SELECTCOLUMNS(
            FILTER(
                CROSSJOIN('Time', 'period'),
                'Time'[period] = 'period'[Period] &&
                'Time'[quarter] >= 'period'[quarter] - 1 &&
                'Time'[quarter] <= 'period'[quarter] - 5
            ),
            "period", 'Time'[period]
        )
    )
)