Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |