Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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.
Can I know what is it that I'm missing what should I pay attention to?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |