Fiscal week on Fiscal Week change calculation not working. Social Dashboard

[NDYKES]

Hello,

I have attatched the PBIX file for reference, am a bit stuck on something.

I am building a social media dashboard to track weekly performance across key metrics, I run the data daily [dateran] and I capture all active posts on the page usually the most recent X [timeposted].

I want to compare this fiscal weeks performance by last fiscal week which in theory sounds easy but I keep getting errors, I lookeed at this but to no avail.

https://community.powerbi.com/t5/Desktop/Week-over-Week-Change/m-p/245447#M108771

As you can see here when I look at the data for Brand A and B by fiscal year the sum of likes table changes, however across my 3 calculated columns, posted TW, posted LW and a test calculation from above I get different but wrong results each time.

A simple version of my table structure is below and it is joined to a date table with timeposted linked to date.

Below is a we transfer link to my PBIx example file

https://wetransfer.com/downloads/b7bc0ef6a8e7421657256bbdd381676620190731131813/7fa7532f67656d139adb...

Any help would be appreciated greatly.

Thanks

Nick

[v-xuding-msft · Accepted solution]

Hi @NDYKES ,

I created a measure using the following foemula. Is this what you want?

Measure = CALCULATE(SUM(Brands[likes]),FILTER(ALLEXCEPT(Brands,Brands[brand]),Brands[Fiscal Week] = MAX(Brands[Fiscal Week])-1))

Best Regards,

Xue

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

[NDYKES]

Beautiful!

Thank you so much

[NDYKES]

EDIT: 

My formula are as such:

Sum of likes LW = CALCULATE([Sum of Likes],Brands[7 Days Ago])

Sum of likes posted LW 2 = CALCULATE([Sum of Likes],DatesPost[Last Fiscal Week])

Sum of likes posted TW = CALCULATE([Sum of Likes],Brands[Fiscal Week]-1)

---

@NDYKES wrote:

Hello,

I have attatched the PBIX file for reference, am a bit stuck on something.

I am building a social media dashboard to track weekly performance across key metrics, I run the data daily [dateran] and I capture all active posts on the page usually the most recent X [timeposted].

I want to compare this fiscal weeks performance by last fiscal week which in theory sounds easy but I keep getting errors, I lookeed at this but to no avail.

https://community.powerbi.com/t5/Desktop/Week-over-Week-Change/m-p/245447#M108771

As you can see here when I look at the data for Brand A and B by fiscal year the sum of likes table changes, however across my 3 calculated columns, posted TW, posted LW and a test calculation from above I get different but wrong results each time.

A simple version of my table structure is below and it is joined to a date table with timeposted linked to date.

Below is a we transfer link to my PBIx example file

https://wetransfer.com/downloads/b7bc0ef6a8e7421657256bbdd381676620190731131813/7fa7532f67656d139adb...

Any help would be appreciated greatly.

Thanks

Nick

---