Time Intelligence Functions - Help (PREVIOUSQUARTER, PREVIOUSMONTH, etc)

[kchan]

Hi All,

I've been trying to get this working with my data with no success. I followed instructions found in the related posts but I keep coming up with a blank/wrong results.

I tried the basic tutorial scenario using the Contoso Sales sample data but I still can't get previousquarter, previousmonth to work.  They just return blank.

When I use the parallelperiod method it works with Contoso data but with my data it just returns the same result as the context.  Eg. previous month is the same as the current month

I'm lost, anyone else encounter this issue?

Thanks!

[v-haibl-msft · Accepted solution]

@kchan

For the Contoso Sales sample, I used following two measures to get the sales amount of previous quarter/month. I’ve uploaded my Power BI file here. Please take a look at it to see if there is any difference with yours.

Sales_PreviousQuarter = 
CALCULATE (
    SUM ( Sales[SalesAmount] ),
    PREVIOUSQUARTER ( 'Calendar'[DateKey] )
)

Sales_PreviousMonth = 
CALCULATE ( SUM ( Sales[SalesAmount] ), PREVIOUSMONTH ( 'Calendar'[DateKey] ) )

Best Regards,

Herbert

[kchan]

Thanks Herbert.

My formula wasn't wrong just the context of the date key was wrong.  I kept using the full date and realized it once I saw your file.