Hi, I have a issue where I'm trying to get the value(decimal number) as my output in a measure, but it needs to filter to MIN timestamp of that task and another filter. How can I get this? min timestamp value of minutesleft = CALCULATE(SUM(Table[minutesleft of workday]), Table[tasknumber] = 72, Table[isMain] = TRUE(), FILTER(Table, Table[originalTimeStamp] = MIN(Ark2[originalTimeStamp])))
I've tried this, but if there are values before what I would like (e.g different tasknumber) my measure returns blank. Any good ideas on how to get just this one value. I would like to not create a calculated column to get the answer for this.
That looks really good and works, however, when I tried adding more ID's it stopped working correctly and gave something else in a table I created. I would like to compare different ID's and this is an issue then. Looks to be working when i filter for only on ID.
Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.