SQL query to DAX

[AshPower]

Looking to convert this SQL query in DAX. Any help is much appreciated.

select phonemodel,CreationDate,sum([Failed])
FROM [DVDB].[dbo].[DailyStatus]
where CreationDate = (select max(CreationDate) FROM [DVDB].[dbo].[DailyStatus])
group by phonemodel,CreationDate

[v-sihou-msft · Accepted solution]

@AshPower

You can write DAX like below:

EVALUATE
VAR MaxDate =
    CALCULATE ( MAX ( DailyStatus[CreationDate] ) )
RETURN
    FILTER (
        SUMMARIZE (
            DailyStatus,
            DailyStatus[phonemodel],
            DailyStatus[CreationDate],
            "Total Failed", SUM ( DailyStatus[Failed] )
        ),
        [CreationDate] = MaxDate
    )

Please also refer to article below:

https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/

Regards,