Forum Discussion

Nethunt's avatar
Nethunt
Frequent Visitor
8 years ago

Report data from same week previous year

Appended dataqueries from several companies to a new query in Power BI. Every company query has almost the same columns (YearWeek, SalesTotal, SalesA, SalesB, SalesC, ........). Before appending i ...
Need Help
Nethunt's avatar
Nethunt
Frequent Visitor
8 years ago

Thanks Xiaoxin Sheng, again a little step closer. 

 

As mentioned before, when these were salesdata from the year 2017, the line should give the totals of 2016. Now column and line are from the same year.

 

Greetings

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Nethunt,

 

I think you can add '-1' to filter on pervious year.

LAST YEAR sales total = 
VAR current_company =
    LASTNONBLANK ( 'GROUP'[Company], [Company] )
RETURN
    CALCULATE (
        SUM ( 'GROUP'[salestotal] ),
        FILTER (
            ALL( 'GROUP' ),
            'GROUP'[Year]
                = SELECTEDVALUE('Table'[Year])-1
				&&'GROUP'[Week]= MAX('GROUP'[Week])
                && 'GROUP'[Company] = current_company
        )
    )

 

 

Regards,

Xiaoxin Sheng