Forum Discussion
Calculate difference using 2 dates in 1 table
btalahmbong you need to use the userelationship function
when you create relationships to your calendar table (assuming you have one?), there can be only one primary (active) relationship, that will be the default, the inactive relationship will have a dotted line
can you post a pic of your relationships.
therefore for your measure for the inactive relationship, say its the resolved on date
calculate(measure, userelationship([table]resolvedondate, calendar[date]))
btalahmbong you need to use the userelationship function
when you create relationships to your calendar table (assuming you have one?), there can be only one primary (active) relationship, that will be the default, the inactive relationship will have a dotted line
can you post a pic of your relationships.
therefore for your measure for the inactive relationship, say its the resolved on date
calculate(measure, userelationship([table]resolvedondate, calendar[date]))
vanessafvg Thanks a lot.
I already had an inactive relationship (Case[modified.Id], User[User Id]) on the 'cases resolved' measure so didn't know it was possible to have more than 1 inactive relationship on a measure. But that worked perfectly. Thanks a lot.