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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Krisso1975 ,

 

What is this [uvw Period Details.Current] column? Is it a column to identify if the records is current or last year?

Regardless this column, If you have date column, you could use year([date]) to get the year of date and year([date])-1 to get last year.

So the measure shoule be like:

last year =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        YEAR ( 'Table'[date] )
            = YEAR ( SELECTEDVALUE ( 'calendar'[date] ) ) - 1
    )
)

If I misunderstood your meaning, please show some sample data and expected result.

 

Best Regards,

Jay

Krisso1975's avatar
Krisso1975
Regular Visitor
4 years ago

Hi Jay,

 

In power query I have a table of period details that is merged in with the data i am using Current is a reference to if todays date falls between the 1st of the month and last of the month = Table.AddColumn(#"Changed Type1", "Current", each if([Current Date] >= [PeriodStartDate]) and([Current Date]<=[PeriodEndDate]) then "Current" else "Previous") which then I use to pull the current periods data.

 

I tried your solution but got a blank result. I this something I could similar in power query to find the same period 1 year back rather than doing through Power BI measures?