Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rushikesh_27
Frequent Visitor

Userelationship function giving blank results.

Hello all,
I'm trying to use the userelationship function for a model.
I have 3 tables. Calendar, Shipment, Sites

Where Calendar(date)is connected to 2 dates of Shipment( early_ship date-active, loddte only-inactive) 

Sites(wh_id) is connected to Shipment(wh_id - active)

rushikesh_27_0-1660051048317.png

 

 

I'm trying to calculate the sum of Cases loaded(loose,layer,full pallet) based on loddte only.

DAX  used- calculate(sum(Shipment(Loose Sc Loaded)),userelationship(Calendar(Date),Shipment(Loddte only))

There are values for any dates filter, but still getting blank values. (Never seen blank values for userelationship function)
I have the same date type.
I'm using Calendar Date as filter. Site(Wh_id) as another filter to select sites.

rushikesh_27_1-1660051048157.png

 

Can I know what is it that I'm missing what should I pay attention to?

2 REPLIES 2
amitchandak
Super User
Super User

@rushikesh_27 , Make sure date table have all the dates.

 

Makse sure that Loddte only date have no time stamp - Change data type to datetime and select format with time. Time stamp should be 00:00 or 12:00.

if that is anything other than that then create a date column

 

Loddte only date = datevalue([Loddte only])

 

join date with that and use

Thank you for the support.
Made sure that the date does not have any time stamp. The Calendar date is having all he dates as well.
Still shows blank values.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.