If you have been working with Power BI for a while now you might have come across the standard Power BI actions in Power Automate. They allow you to automate (…) Read more
Posts Tagged ‘Power BI’
Create Power BI Metrics/Goals Scorecards from Excel files using Power Automate
I like Power BI scorecards a lot, as they give a really nice interface and look to your and your teams goals. However, entering all goals manually can become a (…) Read more
Forecasting with seasonality in Power BI
Today I’m starting a small series about forecasting in Power BI. In this blogpost I’ll start with a basic example about forecasting with seasonality that I will build upon in (…) Read more
TRIMMEAN function for Power Query and Power BI
TRIMMEAN is a statistical function in Excel that calculates the “mean taken by excluding a percentage of data points from the top and bottom tails of a data set”. So (…) Read more
Excel WEEKNUM function for Power Query
If you are looking for the Excel equivalent of the WEEKNUM function for Power Query this article is for you. As this is also a function that has many regional (…) Read more
Excel YEARFRAC function for Power Query
While there is a native YEARFRAC-function in DAX that you can use to calculate year fractions, sometimes you might just need it in Power Query. The function I’m presenting here (…) Read more