Issues with last year revenue

[Anonymous]

Hello, 

I created a Calendar table;

And relationed with the date column of my order table;

Then I created a measure to sum the revenue of the last year

10M - Revenue LY = CALCULATE([01M -Total Revenue], SAMEPERIODLASTYEAR('Calendar'[Date Emissão]))

But when compared the values in a table graphic, something strange happens;

It's just ignoring more than 50% of the value, its like it can't find a date to it, but if we check the date columns of both tables;

Calendar has dates from 01/01/19 til 31/12/2021

And if we check date column from order table we see that;

It has date from 04/01/2019 until 12/07/2021 (today)

Why this is happenig?

[amitchandak · Accepted solution]

@Anonymous , check if the date of the table joining to join to the calendar is having a timestamp.

You need to make date as date time and choose a format with time to check.

If it has time create date without time and join with calendar

This should work

10M - Revenue LY = CALCULATE([01M -Total Revenue], SAMEPERIODLASTYEAR('Calendar'[Date Emissão]))

10M - Revenue LY = CALCULATE([01M -Total Revenue], dateadd('Calendar'[Date Emissão],-1,year))

also, make sure the Calendar is marked as a date table 

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

[Anonymous]

Alright, but how do I create date column without timestamp?  I copy the former date column?