User Profile
hools
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Re: TRIMMEAN
Thank you so much for this. It works! But of course, I tried it with about 150,000 rows of data, and, yep, it's quite slow! For small-ish datasets, it's OK, but even for medium-sized ones with an Intel Core I9 solid state drive Dell all-singing all-dancing desktop, it's too slow. So I resorted to manipulating my data with M, grouping the data and coming up with a calculated column (in M) from which I could exclude the tops and tails with a simple CALCULATE measure in DAX. But thank you, thank you for this DAX measure ... lots of interesting stuff in there for my file of "useful hacks".44KViews0likes0CommentsRe: Can't get 'Publish to Web' to appear?
I spent several hours trying to find the solution to "publish to web" - I am the admin. The solution was that I need to have the dataset and the report in the same workspace. You won't find the option to publish to web if reports using a shared dataset are stored in different workspaces. So keep you reports and datasets in the same workspace!15KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.