Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm stumped on what should be a simple exercise, and my attempts have not been successful. Hopefully you folks can help.
I've tried variations of IF statements and Lookups and have had no luck.
My goal is to return the value of Column B into Column C if the value in Column A equals to 1/10/2020, otherwise return 0.
The result should look like this:
Thank you in advance!
Solved! Go to Solution.
Hi @peterso ,
Try using Add Column --> Conditional Column
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@peterso ,
M
Column C = if [Column A] =Date.FromText("2020-01-01") then [Column B] else 0
Dax
Column C = Switch( True() , [Column A] =Date(2020,1,1) , [Column B], 0)
Hi @peterso ,
Try using Add Column --> Conditional Column
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @peterso ,
shared the solution at
Let us know if it works.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @peterso
I would create a new column as below
Column C = IF('Table'[Column A]=DATE(2020,1,10),'Table'[Column B],"0")
See below the screen shot for a sample example. Here the date is 02/01/2019(MM/DD/YYYY)
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Where do you want to do that, in Power Query or in DAX?
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |