Category Archives: PowerBI

PowerBI Power Query / M lookups

Posted on May 6, 2022 by pfb_admin

I’m building a dynamic bucketing system with filtering based on process and program. I’m facing several interesting challenges. First- bucket sizes are based on the program, so I need dynamic buckets, and bucket labels. Second- max number of buckets is … Continue reading →

Posted in Business, Business Intelligence, Design and UX, PowerBI | Leave a comment

PowerBI YearMonthDay in formatted new column

Posted on May 6, 2021 by Eric Weberg

This formula will create a zero-padded Year/Month/Day Weekday in PowerBI. For example: 2021/06/15 T Create a new column, and update the formula to use your table name and column name. (‘history'[date] in the formula below.) DateYMD = Year(‘db_datareader uvw_aca_wipinfo'[end_time]) & … Continue reading →

Posted in PowerBI | Leave a comment

Display last refresh date in PowerBI

Posted on March 19, 2021 by pfb_admin

This is basically a copy of sections of Ken Puls’ article at https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/, in case that page is deleted or inaccessible. In his article, Ken discusses the finer points of the issues related to data pull timing versus local timing, … Continue reading →

Posted in PowerBI | Leave a comment

Dynamic Titles in PowerBI

Posted on August 31, 2020 by Eric Weberg

TL;DR: Copy this code into your DAX formatter. Selected Program = VAR _program = IF ( ISFILTERED ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( HASONEFILTER ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( ISBLANK ( SELECTEDVALUE ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ) ), “Unspecified programs”, … Continue reading →

Posted in Business Intelligence, PowerBI | Leave a comment