Forum Discussion
Date relationships
I will preface this that I am still pretty green with PowerBI, so be gentle haha. I'd like to make some visuals with this data to help our IT department. Here is what I'm striving for: Unfortu...
olgad
Resident Rockstar
Resident RockstarHi, you can have only one active relationship between two tables.
So if you want cases opened cases closed you have to create date-open date relationship and make it active, second date-closing date keep it inactive ( but create it)
then for the closing date you will use Userelationship function.
closed cases= Calculate(count(cases), userelationship(date, closing date))
So I created that as a measure, which axis is that going in? And RollingCalendar[date] still doesn't populate anything on the visual in the x-axis