Power BI desktop issue

[Anonymous]

Hi

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

same problem.

[Anonymous · Accepted solution]

found the solution - had to add additional brackets before the IF and after

IF(NumberOfSelectedDays=1, "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)

to

IF((NumberOfSelectedDays=1), "", CONCATENATEX(AllButLastSelectedDay,'DimDate'[EnglishDayNameOfWeek], ", ") & " And ") & LastSelectedDay)