DAX calculation

[ramkula123]

Hi All, 

I need to calculate the difference (in weeks) between weekdays i.e today and weekday (ex : 201920). I have values like 201919,201920,201921 etc in column A in my table .

The expected result is ,if Column A has value 201921 then result should be -1 as we are 201922 week currently .

Thank you.

[v-xicai]

Hi @ramkula123 ,

You can try to create column like DAX below.

Column1= VALUE(MID(Table1[Column A],5,2))-WEEKNUM(TODAY())

Best Regards,

Amy

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

[ramkula123]

@v-xicai Thanks for inputs ! 🙂 

But I have older weeks as well in my column A . I have values like 201821, 201822 etc .

Hence I need to calculate the difference in weeks from 2017 ,2018 to current week. 

[v-xicai]

Hi @ramkula123 ,

Yes, I know your demand. Did the DAX formula fail to meet your demand? Or could you please share your sample data or desired output screenshots for further analysis?

Best Regards,

Amy

[ramkula123]

Hi @v-xicai 

---

---

Please find the screenshot . I have put 3 columns : Input data , Result expected , The result which I am getting using the formula above .