DAXdakan ep5: Random PBI Tips & Tricks

Episode 5 yo! Happy holidays to everyone!

In this episode, we discussed random Power BI Tips and Tricks. From usage metrics report, to decompressing Gzip files in PowerQuery, to using the EmptyCharacter, to using DAX Studio and the latest DAX view pane of Power BI to view your measures, to using the offset function in resetting cumulatives, to auto appending multiple Excel spreadsheets with non-matching column headers.

Special thanks to Daniel (Dane) Belarmino for helping with the last 3 tips. Interested in presenting and helping the community learn? Please reach out to my socials below.

DAXdakan is a monthly Teams meeting with other Power BI Pilipinas members.

Language is Filipino/English. Attendance is free.

This episode is available in Youtube, Spotify, Apple Podcasts, and Amazon Music.

00:00:00 - Video start

00:00:20 - Intro

00:14:33 - PBI Tips & Tricks

01:21:32 - Outro

Connect with our socials:

https://taplink.cc/powerbipilipinas

Episode 5 relevant links:

https://gist.github.com/msdotnetclr/9477258a703468578445d6f029fa64a3

https://www.emptycharacter.com/

Social media icons: vervex.ca

Theme music: "Back to Me" by Aitor Hertz