I use my Own Calendar and Calculate with Last week and Last Month Turn Weird

[Chanleakna123]

hi , 

i have used my own calendar with manually , And there will be some day on 23rd Jan go to February alr. 

and there will be another day to go for the whole year. 

Once i import it , i have used calculation of Total Last Month and Last Week , but the result turns weird and i failed to understand. seems like it doesn't follow my own manual calendar. 

Below link is the Calendar i have created , Can you please try it and get back to me if i did sth wrong or you have another way to make it right ?

 https://www.dropbox.com/s/kjagnqr6q2jk4ef/445%20Calendar.xls%20new.xlsx?dl=0

This is the calculation i have used and it turns weird result. 

Total LW = CALCULATE([Net Placement],DATEADD('Date - Weeks'[Date],-7,DAY))

Total LM = CALCULATE([Net Placement],DATEADD('Date - Weeks'[Date],-1,MONTH))

[v-cherch-msft]

Hi @Chanleakna123 

When you use date table,please make sure you've linked the sample data table and date table.Then use date table's date column as dimension.If you need further help,please share a simplified sample file for us to test.You can upload the .pbix file to OneDrive and post the link here.

Regards,

[Chanleakna123]

hi @v-cherch-msft , 

kindlly find the link below : 

https://www.dropbox.com/s/vi4olrwmkpo9qjh/Testing%20Cooler.xlsx?dl=0

Hi , Can you help me to do Total Last Month and Total Last Week of Coolers or Fountain ? 

through my 445 Calendars i shared ? 

Thanks with Regards, 
Chanleakna Hang 

[v-cherch-msft]

Hi @Chanleakna123 

Please check if below posts could help you.

https://community.powerbi.com/t5/Desktop/Calculate-Week-over-Week-change-based-on-Number-of-weeks-si...

https://community.powerbi.com/t5/Desktop/Variance-between-two-measures/m-p/588970#M279325

Regards,

[Chanleakna123]

@v-cherch-msft  hi dear , i have searched around and failed to get the result even the link you sent is not my expectation. Can you please assist to the sample one for me as the table i shared in Dropbox ? 

Thx 

[Chanleakna123]

hi @v-cherch-msft , do you have any idea how to settle this ? 

Thanks you