Forum Discussion

Krisso1975's avatar
Krisso1975
Regular Visitor
4 years ago

PY Period figure

Hi All   Is there any way to copy this measure so that I can see last years same period figures?   This Period Billing = CALCULATE(Sum(Billing[SplitAmount]),Billing[uvw_PeriodDetails.Current]="C...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Krisso1975 , if you have a date then join it with date table

 

CALCULATE(Sum(Billing[SplitAmount]),SAMEPERIODLASTYEAR('Date'[Date]))

 

else have column like and then use in filter

 

Year Type = Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)

 

 

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Krisso1975's avatar
Krisso1975
Regular Visitor
4 years ago

Hi Amitchandak

Preview
 
Thanks for the reply. Is that code to go in the report or should I be entering this in power query as a column. I tried the first and the result was when I was expecting last year/this year.

The data is joined using a date table and I successfully have same period for last year working for other columns in the report. I think my issue is that I want to base a measure from a measure in the report and I cant select it in the normal way

 

Thanks