There are tons of options in Power BI to add your custom logic. Varying from SQL expressions at data ingest all the way up to Visual Calculations to add logic on a visual level. But how do they compare to each other, where should you do what?
As I’ve been a fan of making DAX easier since day one, I thought it may be a good moment to highlight the differences between calculation options using DAX in Power BI, like measures and calculated columns and how that is significantly different with Power BI Visual Calculations and how those can make your DAX easier.
Read on for a half-dozen options and some further thoughts about calculation options.