Power Query Solution: Find start & end date for each price - Dates Calculation (PQC05)
#excel #exceltutorial #powerquery
--------------------------------------------------------------------
www.aaa-power.net
--------------------------------------------------------------------
0:00 Intro & reimder of the challenge
1:36 Find end date using: Add Index Column, Date.AddDays
6:00 try/otherwise to replace error, and find today's date using DateTime.LocalNow & Date.From
8:51 Wall of fame and thank you
--------------------------------------------------------------------
To download the excel file:
https://drive.google.com/drive/folder...
--------------------------------------------------------------------
To subscribe:
/ @aaaexcel
--------------------------------------------------------------------
To follow on Facebook:
/ excelispower
--------------------------------------------------------------------
To follow on LinkedIn:
/ amratef