Forum Discussion

AshPower's avatar
AshPower
Frequent Visitor
9 years ago
Solved

SQL query to DAX

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

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    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,