Forum Discussion
Excel Power query
Excel Power Query : First tab contain drop of dates for ex.. MonthEnd Any date is selected in the first tab filters the data in secon tab file ex FSBV Below logic retrieves first row, let monthE...
Use this formula for year 2023
= List.Transform({1..12}, each Date.EndOfMonth(#date(2023,_,1)))