Forum Discussion
Text.start with if statment
Hi Justas4478 ,
Please try:Text.Start([Day of Week Name], if [Day of Week Name] = "Thursday" then 5 else 3)Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
I manage to get it to work with this:
if [Day of Week Name] = "Thursday" then Text.Start([Day of Week Name],5) else Text.Start([Day of Week Name],3)
But I think there is better and shorter way to write this code.
If anyone has better solution please let me know.
Hi Justas4478 ,
Please try:Text.Start([Day of Week Name], if [Day of Week Name] = "Thursday" then 5 else 3)Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thank you it works.