negative

3 Topics

Time Delta with negative hour handling
Good Afternoon, I am currently looking for a solution to get the duration between two Date-Time value. The issue is that I have to handle positivie and negative hour like in these 3 different scenarios : End time > Start time End time < Start time End date <> Start date Here an exemple of the 3 scenarios. Activity Type Start time End time Drive 20-10-21 00:06 20-10-21 00:11 Time correction 20-10-21 01:10 20-10-21 00:06 Drive 20-10-21 23:06 21-10-21 00:22 Do you know how I can have the duration in hh:mm:ss of each activity ? Thank's in advance, Don
Solved
DonPepe
4 years ago Place DAX Commands and Tips
2.4KViews
0likes
4Comments
Calculate Sum of weekly value only if previous week was negative
I am trying to do a running sum af resource availability. But if a resource is over-used the previous week, I would like to subtract it from the current week. If it is under-used I do not want it to carry forward. For instance: Capacity 14 14 14 14 14 Orders 12 16 13 12 10 Available 2 -2 -1 1 4
Anonymous
5 years ago Place DAX Commands and Tips
1.2KViews
0likes
3Comments
MINX not considering negative values
I created the following measure to calculate the % change in the weight of food items each week. Running % Change = VAR Latest_Week = CALCULATE(MAXA('Weight'[Week]),'Weight'[Weight (Kg)]<>0) VAR First_Recorded_Week = CALCULATE(MINA('Weight'[Week]),'Weight'[Weight (Kg)]<>0) VAR Weight_FRW = CALCULATE(SUMMARIZE('Weight','Weight'[Weight (Kg)]),'Weight'[Week]=First_Recorded_Week) VAR Weight_LW = CALCULATE(SUMMARIZE('Weight','Weight'[Weight (Kg)]),'Weight'[Week]=Latest_Week) RETURN (Weight_LW - Weight_FRW)/Weight_FRW I added the measure to a graph and was able to see the percentage change, for which some values are negative, so -4%). I want to now display on a card, the name of the item which has the greatest % loss in weight between the first week and current week (so the lowest percentage change). I thought a MINX measure would work in this scenario, but it hasn't for me. Values below 0 are not being picked up, so the wrong product name is being displayed. I would like help on this please.
Solved
ao352
7 years ago Place DAX Commands and Tips
3.8KViews
0likes
7Comments