Tag: DAX Power BI

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

One thing that can seem like a limitation of Power BI is its calendar date table. Often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in either

Continue reading

Formatting DAX Code In Power BI

Effort here will pay dividends later Placing effort into formatting your DAX code will make a huge difference as you build out your data models in Power BI. DAX, at times is a confusing language as it is, so as soon as you get into the slightly complex territory unformatted DAX code becomes almost impossible to

Continue reading