MoM, YoY,WoW comparison

[nish18_1990]

Hi ,

I have data like below.

I need to show values based on selection of calendar date which is not available in data . I need to show comparison based on MoM,WoW,YoY

For MoM selection :

For YoY it should be like below : Compare selected month year with previous year 

For WoW : show the week of selected date and previous week .

It would be good if you can provide the power Bi file for seeing the results and functionality . 

Thanks

[v-hashadapu]

Hi @nish18_1990 , Just checking in—were you able to resolve the issue?
If one of the replies helped, please consider marking it as "Accept as Solution" and giving a 'Kudos'. Doing so can assist other community members in finding answers more quickly.
Thank you!

[v-hashadapu]

Hi @nish18_1990 ,
I hope the information shared was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!

[v-hashadapu]

Hi @nish18_1990 ,
I wanted to follow up and see if you’ve had a chance to review the information provided here.
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!

[v-hashadapu]

Hi , Thank you for reaching out to the Microsoft Community Forum.

Please refer attached .pbix file and see if it solves your issue. A few changes maybe needed. If it does not help, please provide more details. 

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[nish18_1990]

Thank you the logic worked . I need to show percentage total for Tables only . When i put a filter on Tables as category it by defaults changes to 100% . Is there any way to solve it ?

[v-hashadapu]

Hi @nish18_1990 , Thank you for reaching out to the Microsoft Community Forum.

From what I understand, you want to show % total of all categories. I am not sure what DAX measure you are using here but to not default to 100%, you can make use of ALL filter here, it removes any outer filter context and calculates the expression by removing it in DAX.

So, this is how it would go-

Percentage of Total =

DIVIDE(

    COUNT('Items'[ID]),

    CALCULATE(

        COUNT(Items[ID]),

        ALL('Items'[Category])  -- This removes the Category filter

    )

)

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.