Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
It has date from 04/01/2019 until 12/07/2021 (today)
Why this is happenig?
Solved! Go to Solution.
@thatjoey20 , 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
@thatjoey20 , 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
Alright, but how do I create date column without timestamp? I copy the former date column?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |