SCOOPS

1. Power Query – How To Create Month and Year From Date Column
2. How To Get Current Date In Power Query – Date Time Format
3. How To Get Current Date In Power Query – Date Format
4. How To Get Current Month In Power Query

Power Query – How To Create Month and Year From Date Column

To extract month and year from a date column in Power Query

1. Add custom column
2. In Custom column:
   • Date.Month([Date Column Name])
3. If you’d like to combine both month and year into one column:
   • Date.totext(Date.Month([Date])) & Date.totext(Date.Year([Date]))
   • If it is a number column, you use Number.ToText()

How To Get Current Date In Power Query – Date Time Format

use DateTime.LocalNow()

How To Get Current Date In Power Query – Date Format

use Date.From(DateTime.LocalNow())

How To Get Current Month In Power Query

use Date.Month(DateTime.LocalNow())