Forum Discussion
writetofaiz
Helper I
5 years agoDAX 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].[...
- 5 years ago
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
amitchandak
Super User
5 years agowritetofaiz , 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