Grouped running total in Power Query
Hits: 13197The following article was written on the occasion of a Power BI User Meeting. It certainly makes more sense
Read moreBatch replacement of wrong values in Power Query
Hits: 3655Do you live in an ideal world, where data is always clean and correct? Or does your company have
Read more
Power BI – Seven Types of Table Joins
Hits: 23312This article “Seven types of table joins” was written in preparation for a user training and I don’t want
Read morePower BI – Display Measures for specific users only
Hits: 6569The use of user roles is an essential element for restricting or preventing access to the data. The following
Read morePower BI – reduce the number of measures using color saturation
Hits: 2473When displaying value changes over time, the past values, the current values and the planned values are often in
Read morePower Query – Adding leading zeros
Hits: 7447In this short article, I’ll show you how to use Power Query and Power BI to populate values with
Read moreOpening the same PowerBI file multiple times….
Hits: 2074Today, I opened accidentally twice the same PBIX file. The standard behaviour would have been an error message, saying
Read moreIn column calculations
Hits: 1608If you want to perform calculations in Power Query, usually you have to add a new column and delete
Read moreExport datasets from Power BI Service to CSV using VBA
Hits: 5339Downloading a Power BI Dataset with VBA wasn’t really a thing I planned to do until Microsoft released the
Read more
