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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors