The what-if-parameter is an amazing tool to calculate different scenarios and how the result would change. However in some cases exact numbers cannot be selected. It seems like they are just missing from the slicer. Why does that happen and more important how can I fix that? In the following article I will go into the details of why the what-if-slicer sometimes has a limited selection and how you can fix that.
It took us some time before wrapping this up, but we’ve finally decided on a winner for our 13th Power BI Challenge. This challenge was about acing documentation, something that we want to put emphasis on especially in terms of its importance.
In this article, I will be sharing a technique using List.Accumulate function to calculate the Exponential Moving Average (EMA) in Power Query. When it comes to recursive operations, the List.Accumulate is indispensable and becomes handy in scenarios of this nature. Read through the blog and download the attached PBIX file to learn more.
I will be sharing a solution on solving the EMA using DAX which provides more control on the slicing and dicing in one of my upcoming blog posts.
I’m going to go through one of my favorite innovations in Power BI from the past year. I’m talking about is external tools in Power BI Desktop. External tools have expanded the capabilities of Power BI immensely, as they integrate with the reporting features and data modeling.