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.
I have a column (Lovet leveringsdato) where if no date has been input the default date is 01.01.1753.
I want to replace all values containing 01.01.1753 with date from column (Levert dato), if other date then keep the date.
I have tried with these formulas:
= Table.ReplaceValue(#"Egendefinert lagt til",each [Lovet leveringsdato], each if Date.From([Lovet Leveringsdato]) = #date(1753, 1, 1) then [Levert Dato] else [Lovet leveringsdato],Replacer.ReplaceValue,{"Lovet leveringsdato"})
and
= Table.ReplaceValue(#"Egendefinert lagt til",each Date.From([Lovet leveringsdato]), each if Date.From([Lovet Leveringsdato]) = #date(1753, 1, 1) then [Levert Dato] else [Lovet leveringsdato],Replacer.ReplaceValue,{"Lovet leveringsdato"})
Here are the columns
Solved! Go to Solution.
Hi @Rune_ Why don't you try to add a conditional column like this.
Hope this helps.
Appreciate with kudos.
Please mark as a solution if this solves the problem.
Thanks
@Rune_
Right click on 1st column,
Select Replace Value, ( Value to find = "1.1.1753" and Replace with "1") click ok,
Select the Replace Step in power query steps pane and modify the code in the middle where it shows "1" to each [Levert dato]
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This did not work. Probably because it is a date column.
My formula work when I tired it on text column. I guess yours will also.
@Rune_
You could try
Replacer.ReplaceValue if its Replacer.ReplaceText
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Rune_ Why don't you try to add a conditional column like this.
Hope this helps.
Appreciate with kudos.
Please mark as a solution if this solves the problem.
Thanks
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |