Forum Discussion

michaelstone's avatar
michaelstone
Icon for Helper I rankHelper I
7 years ago
Solved

Strange behaviour with SAMEPERIODLASTYEAR

Hi,   I'm building a Power BI report which is analysing PoS transaction data so have a fact table (Transactions) with every individual transaction including timestamp and sales amount (Transactions...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi michaelstone ,

    Sorry for my mistake.

    Please modify the measure Total Sales - Previous Year  like below.

    Total Sales - Previous Year =
SUMX (
    'Calendar',
    CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )
)

    Here is the output.

    Best  Regards,

    Cherry

     

     

michaelstone's avatar
michaelstone
Icon for Helper I rankHelper I
7 years ago

Hi v-piga-msft ,

My production PBIX does use the Calendard[Date] column but as you can see from your example, the Total at the bottom of the Total Sales - Previous Year column is still incorrect.

I was only using Transactions[Date] in the visualisation because it showed the underlying problem i.e. that the SAMEPERIODLASTYEAR is not working correctly and is including dates to the end of the month.

Thanks,

Michael

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi michaelstone ,

Sorry for my mistake.

Please modify the measure Total Sales - Previous Year  like below.

Total Sales - Previous Year =
SUMX (
    'Calendar',
    CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ) )
)

Here is the output.

Best  Regards,

Cherry

 

 

  • michaelstone's avatar
    michaelstone
    Icon for Helper I rankHelper I
    7 years ago

    This seems like a workaround for an underlying bug but will accept as the solution.

     

    Thanks v-piga-msft