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 quarter that the date is related to as well? For example, if I select the slicer 7/16/21, one of my visuals would say Quarter 3, and another would be Quarter 2. I already have a date table with the quarter it belongs in, but am struggling with the DAX to do this
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)
)

     

2 Replies

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member
    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