Forum Discussion

RobbLewz's avatar
RobbLewz
Icon for Helper II rankHelper II
5 years ago

Getting prior group totals in table v

I'm using a table visual instead of a pivot table visual as I wont to include prior totals.   I have 2 SQL tables,  DimEmployee ( EmpId INT , EmpName VARCHAR)   FactSales ( EmpId INT , year ...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

RobbLewz 

If I Have understood correctly, you want a comparison of current year to last year.

In that case, I suggeste create a separate Date Table

and use simple CALCULATE(Measure,SAMEPERIODLASATYEAR(DateDIM[Date])) will get you the required result.

If my understanding is not clear then give me a sample data point and the required out come as picnote to help you

RobbLewz's avatar
RobbLewz
Icon for Helper II rankHelper II
5 years ago

Hi, no I want everything before the selected year which comes from the slicer.

 

I have data from year 2015 to 2021.

 

If I selected 2020 in the slicer, then I want to see the sum of all 2015-2019 and then april - march for 2020