Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone
I was wondering how to do this in Power BI.
Basically I have a column which has a row that contains a certain value that I want to use to populate another column entirely. For example below:
Can someone please tell me the power query to do this or if there are options within the menu?
Thanks in Advance
Solved! Go to Solution.
Hi
Try following M code
if Text.End([#"Date/Time"] , 2) = "PM" or Text.End([#"Date/Time"] , 2) = "AM" then null else [#"Date/Time"]
Then Fill Down.
Thank you.
Hi
Try following M code
if Text.End([#"Date/Time"] , 2) = "PM" or Text.End([#"Date/Time"] , 2) = "AM" then null else [#"Date/Time"]
Then Fill Down.
Thank you.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |