How to view variations without calendar table

[Syndicate_Admin]

Hello, how are you?

This is my first time using this forum. I'm trying to do an analysis that I couldn't.

I need to calculate the difference of "cumpl_meta" with respect to the previous "staff week"

But I do not know how to do it since the information does not come with dates but only with week number, so I can not do it through dateadd.

Could someone tell me if it can be done and in what way?

From already thank you very much!

[Syndicate_Admin]

Hello, Someone could help me with the doubt I raise above?

It would be very helpful!

Thank you.

[Syndicate_Admin]

Here I give an example so that you understand what I want to do. (in this case filter by 1 evsid, but the idea is to do it for everyone)

I want a column that brings me the difference of the goal meeting with respect to the previous staffweek, that is, the difference of staff week 23 compared to staff week 22 would be 71% (241% - 170%)

[Syndicate_Admin]

Hi, how are you? Thank you very much for the reply.

Do I annoy you if I ask you to clarify me a little more? I'm new to power bi

The idea is to see the difference of "goal fulfillment" if it improves or deteriorates, with respect to the previous staff_week, of each evs id (these are repeated week by week)

As I said, I do not do it with dateadd because the date does not exist, it is actually that only "staff_week"

From already thank you very much!

[v-yinliw-msft]

Hi @Syndicate_Admin ,

I think you can use the earlier function to calculate.

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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