Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
evpote01
Regular Visitor

Measure for Previous Year's Data

Hello!

 

I have a question that I think will be simple to answer, but I can't seem to figure out the correct solution.

 

I have a variable, Year, as a slicer on my dashboard. 

 

I have already created a measure called Cost per Client which was done by doing Cost per Client = DIVIDE(SUM('Table'[dollars paid]), [Client Count])

 

I am wanting to also display Cost per Client for the previous year, but want to keep my Year slicer for other data fields that I have. Year is the only date field that my data has. Is there a way to calculate Cost per Client for the previous year?

 

Thank you in advance!

1 ACCEPTED SOLUTION
evpote01
Regular Visitor

Thank you for the help!

 

I was able to get it done by doing 

CALCULATE([Cost per Client], REMOVEFILTERS(Table[year]),PREVIOUSYEAR(Table[date]))
 
where the date variable was in the mm/dd/yyyy format.

View solution in original post

2 REPLIES 2
evpote01
Regular Visitor

Thank you for the help!

 

I was able to get it done by doing 

CALCULATE([Cost per Client], REMOVEFILTERS(Table[year]),PREVIOUSYEAR(Table[date]))
 
where the date variable was in the mm/dd/yyyy format.
Anonymous
Not applicable

Sure you can through Time Intelligence functions with DAX, you'll only need a Date column/field. 

https://docs.microsoft.com/en-us/dax/previousyear-function-dax Look for the example in that link, basically it is what you are trying to achieve. It would be something similar to P_Year = CALCULATE( [Cost Per Client], PREVIOUSYEAR(Table[DateColumn])

 

Similar functions you can consult as well:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax 

https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.