Forum Discussion
icbd
Helper I
Helper ITotal planned production time calculation
Good morning everyone. I am using PowerBI to visualize data in a SQL database. I am trying to make a measurement that will calculate the total planned production times. I have three different...
I was able to do this properly using the following by creating a calculated column containing the Date&ShiftId. I named this ShiftDate.
From there, I used the following DAX formula:
SUMX((DISTINCT(DataPartCell1[ShiftDate])), FIRSTNONBLANK(DataPartCell1[ShiftLength],0))
lbendlin
Super User
Super Userwhat does the part production have to do with the length of the shifts?
icbdHelper I
Helper II was able to do this properly using the following by creating a calculated column containing the Date&ShiftId. I named this ShiftDate.
From there, I used the following DAX formula:
SUMX((DISTINCT(DataPartCell1[ShiftDate])), FIRSTNONBLANK(DataPartCell1[ShiftLength],0))