In this blog, I will explain how a redundant ‘Return’ statement in a Power BI Measure can cause huge performance issues.

Querying Premium Capacity Health Metrics using XMLA EndPoint

If you ever need to display lower values above higher values in a line chart ("reverse" the y-axis), you will not (to date) find an option out-of-the-box within the default visuals provided by Power BI. The good news is there is a (relativley simple) way of achieving the same effect (at least with a Line Chart visual).

Join us to thank the Power BI Community for 5 Years of contributions and helping others. Get a sneak peek of the event, and to find out more on our blog.

One of the amazing things around the challenge is the variety of participants and their backgrounds. Sharing thoughts and ideas from individuals with different background and expertise allows us to improve our vision of what’s possible and how we can sometimes see the same problem in a different light.

Excel Functions starting with E

Incremental refresh is great in WORM situations. WORM stands for Write Once Read Many.  (There is a variation to that called WORN.)  Examples are industrial sensor data that will be captured once and will never change again.

In the business world, a frequent scenario is data that changes ever so slightly after it has been initially written.  A simple example would be a transaction record that gets its transaction value corrected two weeks after it was originally written.  A more extreme example would be the Sales Stage of an opportunity - that attribute goes through a whole lifecycle before settling down as won or lost.

This article proposes an approach how to handle the described data sources in a way that incremental refresh can be applied.

Automate the dataflow refresh in Power BI, whenever there is an update in an Excel file stored in Teams/SharePoint.

In practical business, data iteration is widely used, such as present value or depreciation. However, as we all know, DAX is a functional language based on column engine, each row of data is calculated based on its own row context. But sometimes ...

In this blog, I would like to address one of the issues that I came across recently with the RANKX function where the Ranking Score is different, even though the Sales Amount is exactly same.

I have a report with row level security (RLS) implementation; when a user logs in, they have visual filter pre-selected on the last published value, whether they can or can’t access that portion of data.

Advanced methods for accessing the data underlying Power BI matrixes

I really enjoyed recently working through the latest Power BI Challenge from Enterprise DNA. This was not an easy scenario that we were dealing with. We had some HR consultation data and the required analysis was quite unique.