Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Power BI

Hello, I am trying to create a date column using a month column and year column. My formula  is: =1*(Month_Dataset[[Period]&"01/"&Month_Dataset[year])   In the Custom Column box, I am getting the...
Date Calculation Error
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi Anonymous !

     

    You can use following DAX to create a date column;

     

    NewDate = DATE(Month_Dataset[Year], Month_Dataset[Period], "01")

     

    Regards,

    Hasham

  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous , 

     

    You can use #date function :https://docs.microsoft.com/en-us/powerquery-m/sharpdate

     

    =#date([your year column],[your month column],1)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi Anonymous !

 

You can use following DAX to create a date column;

 

NewDate = DATE(Month_Dataset[Year], Month_Dataset[Period], "01")

 

Regards,

Hasham