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(CreationDat...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    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,

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,