How to add new columns to transfer the new WW, Month & Year calculation?

[marry]

Hi everyone,

Would like to seek for the help here, hope the expert could provide some solutions. Thnaks in advance.!!!

I Would like to move back 2 weeks( add 2 weeks) for the pariticular data (Index=Qty), and add some new columns to reflect the new WW, Month and Year.

I have another table in my Power BI is the calender raw data. Would like to refer to this calender table and reflect the result in the new added WW, Month, Year columns. 

Expected Result:

This is another Calender Table in my Power BI: (Please check my PBI file)

PBI file: (It seems I cannot insert the PBI file here directly, I tried to put it in google drive, please let me know whether can see it. )

 https://drive.google.com/file/d/1SslxfMwmjQ_Yl8np31CFKoQ8-pL-QIQy/view?usp=sharing 

Best regards,

Marry

[Ahmedx · Accepted solution]

pls try again

[marry]

Hi @Ahmedx ,

Thank you, I tried your solution into my PBI report.

But popped up below error message, could you advise how to address it? Thanks.

[Ahmedx]

Rather, you have this because of two types of data.
Is your year column a number or text?
if it’s text, convert it to a number using VALUE.

var _year = VALUE('Table1'[Year ])

[marry]

@Ahmedx ,

I appriciated your help!!!! Thanks for that.

It works well now. 🙂

[AmiraBedh]

What is your expected output ?

[marry]

Hi @AmiraBedh ,

Here is the expected output result. Would like to add three more columns to reflect the new Year, new Month, New WW calculation for particular data.