Forum Discussion
USERELATIONSHIP with DATESINPERIOD in Calculated Column
Morning all, Firstly, I have scoured the online forums trying to find the same issue, and while I have found similar ones (2 examples below), none cater for my specific issue so far, which is the in...
Merc100 , Use relationship need to be used in measure. The second one need to be a measure
Try like
CALCULATE (CALCULATE (
COUNTROWS (Alerts),
USERELATIONSHIP (Alert [Onboard Date], 'Date Table'[Date]) ) ,
DATESINPERIOD ('Date Table'[Date], MAX ('Date Table'[Date]), -6, MONTH))
amitchandak - Thanks for taking a look. I tried that but the result was that each month total was added to that of the previous month, essentially as a rolling total, whereas I want to show the last 6 months in their own right. If you look at the file I linked, you can see the formula (without USERELATIONSHIP) worked fine in the Case Table, so I need to find a way to activate the inactive relationship in the Alert Table.