Forum Discussion

Raj341's avatar
Raj341
Frequent Visitor
2 years ago

Last 30 days using dynamic date slicer

Hi All, I am attempting to achieve the following scenario: I have 3 columns: Date, Reasons, and Value. When I click on the date slicer in the matrix visual, the data should reflect the last 30 days...
Need Help
Show and Tell
Tips and Tricks
  • Raj341's avatar
    Raj341
    Frequent Visitor
    2 years ago

    Hi Ashish_Mathur

    Thank you for your response.

    I replicated the same calculation.

    Measure = CALCULATE([D], USERELATIONSHIP(Lines[Date], Calendar_dup[Date]), DATESBETWEEN(Calendar_dup[Date], MAX(Calendar_dup[Date]) - 6, MAX(Calendar_dup[Date])))

    I followed the same process you did in data modeling, but I am encountering a different error:

    Error: The USERELATIONSHIP function can only use the two column references participating in the relationship.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.  Ensure that there is an inactive relationship between the Date column of the Lines table to the Date column of the Calendar_dup table.