Grouped running total in Power Query
Hits: 34689The 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: 6256Do 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: 108086This 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: 19730The 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: 3139When 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: 25723In 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: 3579Today, I opened accidentally twice the same PBIX file. The standard behaviour would have been an error message, saying
Read moreIn column calculations
Hits: 2356If 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: 12377Downloading a Power BI Dataset with VBA wasn’t really a thing I planned to do until Microsoft released the
Read more
