cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CHU Frequent Visitor
Frequent Visitor

Fiscal Calendar LY (by 52 Fiscal Week, 13 Period, Year ) Not summing up in group level

With LY Fiscal (Week)  I was able to Return LY , the problem is it's not suming up in the group. 

 

For exampe, ( see 2 pictures)

2015's LY P1 W1 - W4 (5,359,963; 7,591,123; 8,813155; 8,583,446) matched 2014 P1 W1 - W4,

BUT, 2015's LY P1 (8,583,466) and 2014 P1 (30,347,687) doesnt match. Seems like it always pulling the 4th week of the period of LY as the SUM of the period. And it doesnt sum up yearly for LY. 

 

So i tried With LY Fiscal (Period), but it will only give me the whole period. 

 

What i really need is LY by week but also sum up to the Fiscal Period and Fiscal Year. 

Anyone has similar situation? Your help is appricaited . I have been stuck here for days!...

 

 

LY Fiscal (Week)= 
CALCULATE(
SUM('Data_SI_(D)_Invoice'[Invoice X]),
FILTER(ALL(Lookup_SI_FiscalData),

Lookup_SI_FiscalData[Fiscal Week ] = max(Lookup_SI_FiscalData[Fiscal Week ]) 

&&

Lookup_SI_FiscalData[Fiscal Period] = max(Lookup_SI_FiscalData[Fiscal Period]) 

&&

Lookup_SI_FiscalData[Fiscal Year] = max(Lookup_SI_FiscalData[Fiscal Year]) - 1)
        )

 

 

LY Fiscal (Period) = 
CALCULATE(
SUM('Data_SI_(D)_Invoice'[Invoice X]),
FILTER(
ALL(Lookup_SI_FiscalData),

Lookup_SI_FiscalData[Fiscal Period] = max(Lookup_SI_FiscalData[Fiscal Period]) 

&&

Lookup_SI_FiscalData[Fiscal Year] = max(Lookup_SI_FiscalData[Fiscal Year]) - 1)
        )

Capture2.PNG2014 (LY)Capture.PNG2015(TY)

2 REPLIES 2
Super User
Super User

Re: Fiscal Calendar LY (by 52 Fiscal Week, 13 Period, Year ) Not summing up in group level

CHU Frequent Visitor
Frequent Visitor

Re: Fiscal Calendar LY (by 52 Fiscal Week, 13 Period, Year ) Not summing up in group level

Thank you @Greg_Deckler but it's not what i am looking for.

 

And my goal is to put that into a KPI card to compare the GAP between selected Fiscal Year  VS prior year's  . And add a scliders for user to select Year, Period and Week of their choice. So having them on a table won't work neither. 

 

Thank you for sharing the links. 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 150 members 1,618 guests
Please welcome our newest community members: