Forum Discussion

Timmyyoungm's avatar
Timmyyoungm
New Member
4 years ago
Solved

select a a single date from a date filter and another visual

Does anyone know how I can select a a single date from a date filter and once it is, I have one visual specifically pulling up information for the quarter that the date is in, and the previous qua...
DAX
  • RayWu's avatar
    RayWu
    4 years ago

    Timmyyoungm 
    You should be able to just put the QuarterName in another visual. The slicer will automatically filter the value for the quartername for this first visual. For the previous quarter, you can make a measure like this:

    PreviousQuarter = 
CALCULATE(
    MIN('Date'[QuarterName]),
    DATEADD('Date'[Date], -1, QUARTER)
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Timmyyoungm 

PLease refer to sample file with the solution https://www.dropbox.com/t/stTqD016sOoBVw4D

You need to have a previous date table (just a shadow copy of the date table) with inactive relationship with the date table. Apologies for not being able to share screenshots as I already consumed my limit. Here is the measure code:

Sales Last 2 Quarters = 
VAR RefDate = ENDOFQUARTER ( 'Date'[Date] )
VAR PreviousDates =
    DATESINPERIOD ('Previous Dates'[Date], RefDate, - 2, QUARTER )
VAR Result =
    CALCULATE ( 
        [Sales Amount],
        REMOVEFILTERS ( 'Date' ),
        KEEPFILTERS ( PreviousDates ),
        USERELATIONSHIP ( 'Date'[Date], 'Previous Dates'[Date] )
    )
RETURN
    Result