Power BI Desktop October Update

Power BI Power BI Updates
21

Put the table filter to your calculate into a variable and try it again, make sure you’re seated, first.

22

image
Daniil has just reported it - I also contacted him. Let’s see what happens. Hopefully I don’t find anything else wrong with it tonight, at least…

23

@Craig,

My apologies - I was doing a couple of things at once, and thought you’d repeated the ALLSELECTED. You are absolutely correct - weird bug.

  • Brian
24

@Craig ,

You were right - I was being far too charitable earlier. The more DAX I write under the Oct 2021 update, the more I realize that feature should never have gone to production.

  • Brian

image
image530×746 81.2 KB

1 Like
25

New bug fix has been released 28th October, taking version to 2.98.1004.0 details:

  • Formula bar fixes:
    • “best” available list will be shown as the suggestion list;
    • the parameter hints intellisense widget will cover function contents for multi-line measures;
    • DAX intellisense service is updated to set the right UI culture and respect localized DAX separate options;
    • the parameter hints will be shown when a suggestion is accepted;
    • error won’t be thrown for table names that start with “’”;
    • few icons are added to the suggestions list to make the suggestion clear and avoid confusion;
    • missing function parameter information is added for some DAX functions and now intellisense works for them;
    • the latest icon files will be shown for variable and enum formula bar icons.
4 Likes
26

Well @DavieJoe, I’ve been eagerly awaiting the SWITCH function improvement. For a couple of years in fact!
One of my main uses of Power BI is an accounting PBIX/App which has a SWITCH statement that works some very different DAX in each SWITCH option to arrive at various KPIs, PL amounts, balance sheet numbers etc.
V slow a couple of years ago. More because I was a newbie. But managed to get it down to 3 second report refresh. The Oct update now has that DAX running at about 1.5/1.8s.

So pretty pleased. But you’re right the rest of it wasn’t exciting.

Pete

1 Like