Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Sorry for language, my Dutch is better....
I have now
But it changed in :
= Table.AddColumn(#"Type gewijzigd", "Groep",
each if [duur dossierbehandeling] <= 3 then "0-3" else if [duur dossierbehandeling] <= 6 then #date(2023, 6, 4) else
if [duur dossierbehandeling] <= 9 then #date(2023, 9, 7) else
if [duur dossierbehandeling] <= 12 then #date(2023, 12, 10) else
"zoek")
What is the wright formule for getting #date(2023, 6, 4) ==> 4-6 as text so not a date
Who want to help me
Solved! Go to Solution.
Hi @Nelleke-NL ,
How about this?
= Table.AddColumn(#"Type gewijzigd", "Groep", each if [duur dossierbehandeling] <= 3 then "0-3" else if [duur dossierbehandeling] <= 6 then "4-6" else if [duur dossierbehandeling] <= 9 then "7-9" else if [duur dossierbehandeling] <= 12 then "10-12" else "zoek")
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @Nelleke-NL ,
How about this?
= Table.AddColumn(#"Type gewijzigd", "Groep", each if [duur dossierbehandeling] <= 3 then "0-3" else if [duur dossierbehandeling] <= 6 then "4-6" else if [duur dossierbehandeling] <= 9 then "7-9" else if [duur dossierbehandeling] <= 12 then "10-12" else "zoek")
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
I did that
= Table.AddColumn(#"Type gewijzigd", "Groep", each if [duur dossierbehandeling] <= 3 then "0-3" else if [duur dossierbehandeling] <= 6 then "4-6" else if [duur dossierbehandeling] <= 9 then "7-9" else if [duur dossierbehandeling] <= 12 then "10-12" else "zoek")
and then after <enter> date are coming.... Know I have several time changed the text "7-9" etc and now it is working complete! I think somewhere in "" or "" is a differentcy.
Still learning and thanka a lot for help and understanding.