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

Continue reading
No comments

Discover Your Top Products Per Region in Power BI w/DAX

If you are a business selling products in many different stores or across lot of different regions you will want to understand if there is any commonality in your top or bottom selling products. In this example I run through how you can find your top 2 products using DAX calculations in Power BI to

Continue reading
No comments