Forum Discussion
New Measure
Anonymous , Evening 4 would be 16.
Row context will play role in answer
Try like
if(max([Laikas]) >=time(4,30,0) , max([Laikas]) - time(4,30,0) , 0 )
if(max([Laikas]) >=time(4,30,0) , max([Laikas]) - time(16,30,0) , 0 )
or
if(max([Laikas]) >=time(4,30,0) , datediff(max([Laikas]), time(4,30,0),minute) , 0 )
if(max([Laikas]) >=time(4,30,0) , datediff(max([Laikas]), time(16,30,0),minute) , 0 )
and a sum like
sumx(Values(Table[Indeksas]), if(max([Laikas]) >=time(4,30,0) , datediff(max([Laikas]), time(16,30,0),minute) , 0 ))
or
sumx(Values(Table[Indeksas]), if(([Laikas]) >=time(4,30,0) , datediff(([Laikas]), time(16,30,0),minute) , 0 ))
It still doesn't work, this is my following table. first column is time in the whole number format and then second one is norm that should not be exceeded, if it exceeds this norm, then return the difference(Third column) between the two, but if it does not exceed 04:30 then return 00:00:00.
Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
That's all i have at the moment. So basically first column you see with the time values, but in format as a whole number. Second column should be the drive time norm that should not be exceeded. Now the third column should do the following: If first column(klaipėda - radviliškis) exceeds second column value, then we should return the difference between the two(actual first column and second column). If first column value does not exceed second column, then we should just return actual time in the first column.
Hi Anonymous ,
Anonymous wrote:That's all i have at the moment. So basically first column you see with the time values, but in format as a whole number. Second column should be the drive time norm that should not be exceeded. Now the third column should do the following: If first column(klaipėda - radviliškis) exceeds second column value, then we should return the difference between the two(actual first column and second column). If first column value does not exceed second column, then we should just return actual time in the first column.
Sorry, I don't quite understand that. Could you share a sample pbix to let us know more about the scenario.(Please mask any sensitive data before uploading)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
