Forum Discussion
Return a value based on a postingdate
Hello Community I have checked some posting and I am not sure how to go about this. I have 2 tables Table1 has some items, amounts and a saledate Table2 has the date ranges and the week num...
mahoneypat
Microsoft Employee
Microsoft EmployeeI assume you are looking for a calculated column. You can try this expression:
PeriodName = var datethisrow = Table1[SaleDate]
return Calculate(min(Table2[PeriodName), Filter(All(Table2), Table2[StartDate] <= datethisrow && Table2[EndDate]>= datethisrow))
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat