Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Date switch with one period seems to not show right results



I've been trying to solve this issue, but w/o success, tehrefore I came here for help. 


My main issue is concerning the date differnce in past (year, month etc.) tyo ompare witrh current values. 


I have uploaded 2 types of files:

  • one raw data from an excel file where the data is already structured (from monthly level to daily level) "13" raw data"
  • one in which I try to take monthly figures and divide them via a working days table: "13" daily - w formula" in which I divide the Monthly volues to CUD or working days.

Now, when I try to bring the figures from 2022 to 2023, in case of raw data it works and brings all the correct figures, but in case of defined formula, e.g.: for measure 13" daily - w formula, the dateadd measure brings some different figures. altough the calculations gives the correct daily figures. 


I have attached a picture to show exactly how it looks (also the PBI file):

In case of W01 from 2022 w have for measure "13" -> 1373 pcs which both versions calculate corect, but the date add brings different values: 1373 for raw data and 1600 for formula data. 


P.S.: same behavior is also if I use SAMEPERIODLASTYEAR measure. 


PBI File

Test PBI


Any suggestions?


Many thanks! 


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors