fbpx

Setting default values using COALESCE in DAX

Learn how to get default values using the DAX COALESCE function instead of IF statements. A great way to avoid BLANK in Power BI! Documentation: https://docs.microsoft.com/dax/coalesce-function-dax SQLBI.com article: https://sql.bi/659297

Setting default values using COALESCE in DAX2020-03-31T07:50:26-05:00

Power BI updates, tips and Coronavirus… (Roundup | March 23, 2020)

Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup172 2 Minute Tuesday: https://guyinacu.be/aggdefinebroke Patrick's tech video: https://guyinacu.be/hittingaggs Adam's tech video: https://guyinacu.be/gatewaycluster 📢 Become a member: https://guyinacu.be/membership Sources Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity (@MarcLelijveld) From SQL to [...]

Power BI updates, tips and Coronavirus… (Roundup | March 23, 2020)2020-03-23T07:57:51-05:00

MS Teams Power BI Update and more… (Roundup | March 2, 2020)

Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup169 2 Minute Tuesday: https://guyinacu.be/rlsmembers Patrick's tech video: https://guyinacu.be/rlsexport Adam's tech video: https://guyinacu.be/customfont 🔴 Recorded Live Stream: https://guyinacu.be/pbiconferences 📢 Become a member: https://guyinacu.be/membership Sources Why and how to Keep Dimensions & Facts tables separate – DAX modeling (@theexcelclub) Power BI: [...]

MS Teams Power BI Update and more… (Roundup | March 2, 2020)2020-03-02T09:54:41-05:00

CRAZY keyboard shortcuts for DAX in Power BI Desktop

Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas! Documentation: https://docs.microsoft.com/power-bi/desktop-accessibility

CRAZY keyboard shortcuts for DAX in Power BI Desktop2019-10-30T08:11:51-05:00

Power BI: Case of the unexplained date (LastDate in DAX)

Adam looks at why the LastDate DAX function is returning the wrong date within Power BI Desktop. Breaking down a twitter conversation. Twitter thread: https://twitter.com/dhawalmehta/status/1183750809646972929 Marco's Blog: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/ Reza's Blog: https://radacad.com/lost-customers-dax-calculation-for-power-bi Calendar Table: https://www.youtube.com/watch?v=gyvhM5eiT0U Reduce data model size: https://www.youtube.com/watch?v=c-ZqToc85Yc Sample download

Power BI: Case of the unexplained date (LastDate in DAX)2019-10-17T09:12:29-05:00