I am experiencing a weird issue with my PowerBI desktop.
Everytime i click on the column wiht a DAX code - it causes a break.
Tested on other PowerBI desktops and it works fine.
I also uninstalled and went back to version 2.65.5313.131
Go to Solution.
found the solution - had to add additional brackets before the IF and after
IF(NumberOfSelectedDays=1, "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)
IF((NumberOfSelectedDays=1), "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!