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.