get MIN, MAX DATE then count duration in hour
hi all; i have data set, https://docs.google.com/spreadsheets/d/159xOcmrKj95YXYOayHmGi9A_K_8ZHIMq/edit?usp=sharing&ouid=100079262241875009342&rtpof=true&sd=true the point is; i already get MIN DATE, and MAX DATE ( with Measurement); but then how to get duration(hour) from that ? i tried using DATEDIFF formula but the result is wrong . First Started = CALCULATE ( MIN ( 'Data'[DateStarted] ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) Last Finished = CALCULATE ( MAX ( 'Data'[DateFinished ), ALLEXCEPT ( 'Data', Data[DateCreate], Data[worker] ) ) duration(hour)= datediff([Last Finished] , [First Started],HOUR) thank you for your help; Azura
Last Sale Date by Sku
Hi! I am fairly new to Power BI and need help finding the last sale date of a sku. I've tried with the following: Date = CALCULATE(max(SOP30200_SalesHeader[DOCDATE]),ALLSELECTED(IV00101_ItemMaster[ITEMNMBR])) but this brings back the last date of sale as yesterday for everything (the last time refreshed). Can someone point me in the right direction? This will help me for other reports I'm building as well. Thank you in advance! Steph
