ZARZA We are Zarza, the prestigious firm behind major projects in information technology.
Listen "DAXdakan ep5: Random PBI Tips & Tricks"
Episode Synopsis
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
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
More episodes of the podcast DAXdakan with Power BI Pilipinas
Data Challenge 2025 DAXdakan
19/10/2025
DAXdakan Again @ AIM (Live #3)
24/11/2024
DAXdakan: Dashboard in an Hour with Copilot
12/10/2024
DAXdakan 1-to-many ep2: Power BI Moderators
15/09/2024
DAXdakan ep8: Career Day with Recruitday
24/08/2024
DAXdakan 1:many with Driz, Abs, & Dale
02/07/2024
DAXdakan Live #2
31/05/2024
DAXdakan Live #1
19/05/2024
DAXdakan ep7: My DP-600 Exam Experience
04/05/2024
In God we trust