Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago
Solved

Add Column Month & Year in Power Query

Hi BI Community Team,   I am getting error as the screenshot when trying to add/combine the column Month No. & Year to new column as the format: 1/1/2022 ---- 1/12/2022.   In Custom column formul...
  • FreemanZ's avatar
    3 years ago

    hi ADSL 

    how about:

    = #date([Year], [Month No],1)