Forum Discussion

madscientist's avatar
madscientist
Frequent Visitor
6 years ago
Solved

Challenge with date calcs

Hi - seeking help from this great community!   I am trying to prepare a table that has full quarter (QTR) and QTD information at the same time using sample data below:   Data: Product      Date ...
date slicers
  • lbendlin's avatar
    lbendlin
    6 years ago

    Something like this (there are many ways)

     

    QTR=

    var currQ = max(Dates[Quarter])

    Return Calculate([amt],Dates[Quarter] = currQ)

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

use CALCULATE to break out of the Month filter context but keep the Quarter filter context.

madscientist's avatar
madscientist
Frequent Visitor
6 years ago

Could you please share an example of what the DAX formula syntax would look like?  Note that I currently do not have a filter for quarter - I only have slicers for Year and Month.

 

My current measures are:

 

QTD = calculate ([amt], datesqtd (dates))

QTR = ????

 

I'm hoping to avoid the need of having a slicer for quarter, as that would seem repetitive once the month is chosen.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    Something like this (there are many ways)

     

    QTR=

    var currQ = max(Dates[Quarter])

    Return Calculate([amt],Dates[Quarter] = currQ)