+ Reply to Thread
Results 1 to 2 of 2

Issue with Sameperiodlastyear function

  1. #1
    Registered User
    Join Date
    09-02-2021
    Location
    France
    MS-Off Ver
    365
    Posts
    1

    Issue with Sameperiodlastyear function

    Hello everyone,

    I have a data model with: value (my sales data) / company / product / Year / Months / date (format : 01/01/2021)

    To analyze this data i calculate the following measures :

    YTD =CALCULATE(TOTALYTD([Sum of Value];Sales[Dte]);Sales[Attribute]="CATTC")

    YTD N-1 =CALCULATE([YTD];SAMEPERIODLASTYEAR(Sales[Dte]);Sales[Attribute]="CATTC")

    Moving year (my last 12 months) = CALCULATE([Sum of Value];DATESINPERIOD(Sales[Dte];MAX(Sales[Dte]);-12;MONTH);Sales[Attribute]="CATTC")

    Moving year n-1 = CALCULATE([MAT];SAMEPERIODLASTYEAR(Sales[Dte]);Sales[Attribute]="CATTC")

    After this calculation i add this measures to a pivot table in order to analyze this data and it perfectly works.



    BUT here my question: when i add a product slicer i have the error message appearing in the attached picture, what is more strange is that i have this error message with some product and it works with others.


    Capture.PNG

    Any idea or tip about this issue ?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: Issue with Sameperiodlastyear function

    Welcome to the forum SalesAnalyst.

    Please see instructions for uploading a sample workbook at the top of this page. HOW TO ATTACH YOUR SAMPLE WORKBOOK:
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF function issue
    By NadeemShafi in forum Excel General
    Replies: 3
    Last Post: 08-31-2019, 11:46 AM
  2. Sin/Cos function issue
    By Hypa1980 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2019, 08:18 AM
  3. PowerPivot SamePeriodLastYear
    By ibuhary in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-03-2015, 09:00 AM
  4. IF function issue
    By mbeyatli in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-04-2014, 12:12 PM
  5. If Function Issue
    By elvishcreampie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2011, 10:19 AM
  6. Function Issue
    By artizan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2008, 10:40 AM
  7. [SOLVED] Help with Sum Function Issue
    By msnews.microsoft.com in forum Excel General
    Replies: 2
    Last Post: 12-29-2005, 04:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1