Forum Discussion
Custom Filtered Individual Columns
Hi JMAlloway ,
Try the following: I added two (DAX) columns to my Date table using the following DAX:
DateAxisValue =
VAR CurrentQuarter = 4
// QUARTER ( TODAY ())
Return
IF (
QUARTER('Date'[Date]) = CurrentQuarter,'Date'[Month],"Q" & QUARTER('Date'[Date])
)
DateAxisValueSort =
VAR CurrentQuarter = 4
// QUARTER ( TODAY ())
Return
IF (
QUARTER('Date'[Date]) = CurrentQuarter, "Q" & QUARTER('Date'[Date]) & 'Date'[Month Number],"Q" & QUARTER('Date'[Date])
)Make sure you change the Sort Column for the DateAxisValue Column to DateAxisValueSort
Then you should be able to produce something like this:
The CurrentQuarter is hardcoded to 4 in the sample, but can also be based current date. Be aware that when the column is calculated there is no filter context active
Jan
if this is a solution for you, don't forget to mark it as such. thanks
Hi JMAlloway ,
I think it is a pretty new function (in DAX). I haven't found it yet in the MSDN, but it is in this guide https://dax.guide/quarter/
Otherwise there are various ways to calculate the quarter:
VAR quarterNumber = ISO.CEILING(MONTH([Date])/3,1) or VAR quarterNumber = ROUNDUP(MONTH([Date])/3,0)
These are still usefull since the QUARTER does not take financial years into account.
Jan
Great - everything works out!