Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
writetofaiz
Frequent Visitor

DAX equivalent of SQL query

Hi

I am new to Power BI. Could anyone please tell me the DAX equivalent of 

SELECT [ClientId],CASE WHEN [Status] = 'Success' THEN 'Success' ELSE 'Fail' END 'Status' FROM [NotificationEvent].[dbo].[NotificationEventLog]
WHERE [Status] != 'Success'
GROUP BY [ClientId], CASE WHEN [Status] = 'Success' THEN 'Success' ELSE 'Fail' END

 

writetofaiz_0-1628814549272.png

 

 

Thanks 

Faiz

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@writetofaiz , Create a new column and use with client in visual

New column in DAX

Status = if( [Status] = "Success" , "Success" , "Fail")

 

refer the series if needed

https://www.youtube.com/watch?v=WlvQ_SGy4iA&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@writetofaiz , Create a new column and use with client in visual

New column in DAX

Status = if( [Status] = "Success" , "Success" , "Fail")

 

refer the series if needed

https://www.youtube.com/watch?v=WlvQ_SGy4iA&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.