Dax Formula for Finding Quarter

Question

Hello everyone,I need a DAX formula as measure or calculated column to generate a report with data for the current quarter, previous quarter, and the last two years of all quarters in a single column for single selection date value in a slicer. Help me to find a solution.Example :If Selected date is 10-Feb-2025, I need value likeCategory&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ValuesQuaters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q1-23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q2-23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q3-23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q4-23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q1-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q2-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q3-24Previous Quaters&nbsp; &nbsp; Oct-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nov-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dec-24&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q4-24Current Quarters&nbsp; &nbsp; Jan-25Current Months&nbsp; &nbsp; &nbsp; Week1 - 3 Feb(First Monday of week )

rajendraongole1 · Answer

Hi&nbsp;Donglee26&nbsp; - I hope you already have a date table, if not&nbsp;create a calculated table that dynamically generates the required quarter and month breakdown based on a selected date from a slicer.
&nbsp;
DateTable = ADDCOLUMNS (CALENDAR (DATE(2020, 1, 1), DATE(2030, 12, 31)), "Year", YEAR([Date]),"Month", FORMAT([Date], "MMM-YY"),"Quarter", "Q" &amp; FORMAT([Date], "Q-YY"),"Week", "Week" &amp; FORMAT([Date] - WEEKDAY([Date],2) + 1, " DD MMM") // Week starts from Monday)
&nbsp;
for dynamic , i have attached pbix with calcluation. please check.
Now add&nbsp;Category to Rows.Add Values to Values.
Hope this helps.

donglee26 · Answer

Hi Rajendraongole, thank for the replyEven if I add&nbsp;&nbsp;Category to Rows and add Values to Values I am not getting my required output,You have tried to add as a measure which you have sent above but it will not work I have already tried of creating measure and calculated column, it will through an error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."&nbsp;

Forum Discussion

Dax Formula for Finding Quarter

2 Replies

Related content

Find Current Quarter

Finding Formula Bar

If formula

formula

DAX Formula Help