Advanced Power Query Problem, Extract Transactions in Last 7 Days of Month - Challenge 134

[@IvanCortinas_ES]

Excellent all these solutions. Thank you, Omid!

[@PowerMquery]

You are welcome

[@mnowako]

Good one! Thank you!

[@PowerMquery]

You are welcome

[@iiissf6736]

Good one as always, it would be interested to put the files

[@PowerMquery]

You are welcome

[@RonDavidowicz]

How come at the 1:03 mark, the end of month function returns the first day of the month?

[@PowerMquery]

Thanks for mentioning, I didnt check that, it is because the Date column is in type DateTime format, it just need to convert it into date first then apply Date.EndofMonth