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 have a measure -- Net_Sales_SPLY = Calcuate(Sum('Table'[SalesAmt]), SAMEPERIODLASTYEAR('CalendarTable'[Date]))
and get the following error every so often.
Not able to fully understand the error message or solve the issue.
I have also tried DateAdd -1 Year - but not able to solve the problem.
Will greatly appreciate some input.
Many thanks,
Pavan
Hi @Anonymous
you may try
Net_Sales_SPLY =
CALCULATE (
SUM ( 'Table'[SalesAmt] ),
SAMEPERIODLASTYEAR ( 'CalendarTable'[Date] ),
CROSSFILTER ( 'Table'[Date], 'CalendarTable'[Date], 3 )
)
Thanks tamerj1.
It is not breaking any more, but the numbers don't seem right.
I should have mentioned earlier that the date in the Table[Sales Amt] is a week ending date, and the date in the Calendar table is a daily date. Not sure if this matters or not.
Thanks again!
Hi @Anonymous
Would you please share a screenshot of your table visual?
@Anonymous
Sorry I mean the report visual. Can you share the results you are getting? What are you slicing by in your report? The Date column from the calendar table or from the sales table?
@Anonymous , You seem to have bidirectional join with with date table, make that single directional.
Also make sure calendar table is marked as date table
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
Thanks amitchandak.
It is not breaking any more, but the numbers don't seem right.
I should have mentioned earlier that the date in the Table[Sales Amt] is a week ending date, and the date in the Calendar table is a daily date. Not sure if this matters or not.
Thanks again!
@Anonymous , the Same week can fall in a different month. Unless you have 445 calendar. But based on weekend date falling in month total should be correct
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |