Forum Discussion

kchan's avatar
kchan
Frequent Visitor
10 years ago
Solved

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

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!

 

 

 

 

 

Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

     

2 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    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's avatar
      kchan
      Frequent Visitor
      10 years ago

      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.