CREATE DATE DIMENSION

[Carlaf_93]

Good morning,

i have a table with some dimensions.

I have a year field and a month one (with numbers like: 1,2,3,4..)

i would like to create a date dimension in this format

'01-02-2018' with always day like 01 and month in this format.

What can i do?

LOAD

YEAR,

MONTH

FROM...

[joaopaulo_delco]

Hi @Carlaf_93 !

     You can use the MakeDate function like below:

MakeDate(YEAR, MONTH) 

or formating using

Date(MakeDate(Ano, Mes),'DD-MM-YYYY')