Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Syndicate_Admin
Administrator
Administrator

How to view variations without calendar table

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!

Georgina229_1-1671637396251.png

4 REPLIES 4
Syndicate_Admin
Administrator
Administrator

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

It would be very helpful!

Thank you.

Syndicate_Admin
Administrator
Administrator

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%)

Georgina229_0-1671720389359.png

Syndicate_Admin
Administrator
Administrator

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
Community Support
Community Support

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.