userrelationship dates doesn't override

Anything related to PowerPivot and DAX Formuale
JMSATIRO
Posts: 2
Joined: Fri Jun 07, 2019 10:18 am

userrelationship dates doesn't override

Postby JMSATIRO » Fri Jun 07, 2019 9:22 pm

Hello everyone, my first post here i don't know if it is the right place though...

I have a table in excel with 7 field dates, and want to create columns with the diference between each one of them in power pivot for that i have created a calendar table to link each date (1 active the others inactive) this way i can create a single date slicer for the graphs using calendar date. the problem is that userralationship formula isn't overriding the active link, formula:

-calculate(sum(calendar[workday]);datesbetween(calendar[date];table1[dataocorrencia];table1[datareceção]);userelatioship(table1[dataocorrencia];table1[datareceção])

but the diference between dates are all calculated based on the active link. can you help me pls!!ty

MattAllington
Posts: 1050
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: userrelationship dates doesn't override

Postby MattAllington » Sun Jun 09, 2019 9:29 am

My guess is you need to use 2 calculate functions. The outer sets the userelationship and the inner calculates the datesbetween
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

JMSATIRO
Posts: 2
Joined: Fri Jun 07, 2019 10:18 am

Re: userrelationship dates doesn't override

Postby JMSATIRO » Wed Jun 12, 2019 9:39 am

can you specify pls


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests