DeimantasFrequent Visitor3 years agoSolvedDate Minu Day Hi Guys, Unofrnutultey I can't find opened thread for this issue. All I'm trying to use is if the function and the return value are true should be the date column -1 day if false return the sa...Show MoreBA_Pete3 years agoHi Deimantas , This should work: if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date] Pete
BA_Pete3 years agoHi Deimantas , This should work: if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date] Pete
BA_Pete3 years agoHi Deimantas , This should work: if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date] Pete
BA_PeteSuper User3 years agoHi Deimantas , This should work: if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date] Pete
Related contentPower Query Todays date minus 1 dayMax Date Minus X DaysDate measure minus one yearFormula for Days back minus 2 days from current dateFilter : day minus 7
