hisackmanFrequent Visitor1 year agoSolvedMatch Between Dates Hello, I'm trying to extract an amount between two dates when matched to another data set. E.g. Create a new column / merge the data by date so that any date can pull one of the "Amounts" be...Show MoreAshish_Excel1 year agoHi,Download PBI file from here.Hope this helps.
IrwanSuper User1 year agohello hisackman in your example, since there is no other condition besides date, why it will take Carrier B on 6/1/24? also why it takes Carrier C on 6/1/25? Thank you?
Related contentMatching datesFind Most Recent Date Relative to another Date Column in Power QueryDate hierarchyService DateFuzzy Date Match
