Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding 1 Week to existing date

Hi,

 

I have a date field named as "CurrentWeekDate". I would like to add 1 week to existing date field.

Existing formula in Spotfire is : DateAdd("wk",1,Date('${CURRENTWEEKDATE}'))

I am trying to do the same in Power BI as : Dateadd([CurrentWeekDate],7,day) and I am not sure if it's correct.

Can you help me in adding week to existing date field in Power BI using DAX.

Sample data for the date is as below,

 

A quick help would be much appreciated.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous Please use below formula to add 1 week

    Column = DATEADD('Table'[CurrentWeekDate].[Date],7,DAY)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous Please use below formula to add 1 week

    Column = DATEADD('Table'[CurrentWeekDate].[Date],7,DAY)