sameperiodlastyear returns total month instead to date

Question

HiI'm quite new to PowerBI and i do not understand why my formula gives me a full month last year march (todays date is 10/3)&nbsp;My formula looks like this:Sameperiodlastyear = CALCULATE(SUM('Sellout-730'[SumOfRP_Positionswert]); SAMEPERIODLASTYEAR('Kalender 1'[Date]))&nbsp;You can see in the table below that on the seperate days it gives me the correct sales data, but the total shows the total turnover in March.&nbsp; Hope someone can help and that this is the formula i have to use - at least thats what all tutorial shows.&nbsp;SameperiodlastyearDate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 382.822&nbsp;&nbsp;&nbsp;&nbsp;01.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 394.818&nbsp;&nbsp;&nbsp;&nbsp;02.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 367.519&nbsp;&nbsp;&nbsp;&nbsp;05.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 357.034&nbsp;&nbsp;&nbsp;&nbsp;06.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 310.275&nbsp;&nbsp;&nbsp;&nbsp;07.03.2019 00:00-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.363&nbsp;&nbsp;&nbsp;&nbsp;08.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 464.177&nbsp;&nbsp;&nbsp;&nbsp;09.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.750&nbsp;&nbsp;&nbsp;&nbsp;10.03.2019 00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.328.280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

christianfcbmx · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Can you share a pbix sample?

anonymous · Answer

Hi&nbsp;christianfcbmx&nbsp;&nbsp;What is a pbix sample and how do i share it?

christianfcbmx · Answer

the .pbix is the file you are using....I want to work over what you have becasue I have the same measure in a pbix I have and when I filter by months I get the right result as total ....I wondering why you can not get it....

if you dont have sensitive data send me your pbix file through this website: www.wetransfer.com (very easy to use...self explanatory)

to this email- [email protected]

:)

christianfcbmx · Answer

anonymous · Answer

Hi&nbsp;christianfcbmx&nbsp;I have send you an excel with some powerpivot and pivot data. I have just made an example - its not the real data, but i still have the problem. It does not give me YTD, but YT full month.&nbsp;&nbsp;2019 goes from 1st jan 2019 to 9th March 2019Same period last year should be:1st jan 2018 to 9th of march 2018&nbsp;Hope you can help.&nbsp;&nbsp;

Forum Discussion

sameperiodlastyear returns total month instead to date

5 Replies

Related content

SAMEPERIODLASTYEAR returns Blank

SAMEPERIODLASTYEAR Returns values for future date

SAMEPERIODLASTYEAR returns bank

SAMEPERIODLASTYEAR()

SAMEPERIODLASTYEAR is blank

382.822	01.03.2019 00:00
394.818	02.03.2019 00:00
367.519	05.03.2019 00:00
357.034	06.03.2019 00:00
310.275	07.03.2019 00:00
- 4.363	08.03.2019 00:00
464.177	09.03.2019 00:00
5.750	10.03.2019 00:00
7.328.280