Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |