Here is an approach that will help you calculate quarter in DAX from the date using various tools like Power BI or Excel data model. The previous post contains a method that is useful not only in Excel but also using Power BI.
Tag: get quarter with INT
Get quarter in Excel from date – fast and easy
As usual in Excel, there is more than one way to get identical results, and the same happens if you try to get a quarter in Excel from date. Excel has multiple functions to do calculations with dates, but at this point, none of them are for quarter calculation.