chuggins143
Board Regular
- Joined
- Nov 10, 2009
- Messages
- 100
Hey all,
Okay, I'm pulling in stock market data... specifically dividend data which I can filter by dates. (example data... Eagle Point Credit Company Inc. (ECC) Dividend History, Dates & Yield - Stock Analysis) I can open the Power Query Editor and use the Date Filter on the Ex-Dividend Date column but I'm limited to only using specific dates... is there a way to filter "is before or equal to" Today()??
I'm new to the Power Tools so this is a learning experience for me. I'm not finding much out there so a point in the right direction would be appreciated.
Thank you,
C
Okay, I'm pulling in stock market data... specifically dividend data which I can filter by dates. (example data... Eagle Point Credit Company Inc. (ECC) Dividend History, Dates & Yield - Stock Analysis) I can open the Power Query Editor and use the Date Filter on the Ex-Dividend Date column but I'm limited to only using specific dates... is there a way to filter "is before or equal to" Today()??
I'm new to the Power Tools so this is a learning experience for me. I'm not finding much out there so a point in the right direction would be appreciated.
Thank you,
C