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.
Hi Guys,
Please I am trying to create new measure this the follwoing:
Solved! Go to Solution.
Hi @Anonymous,
If the issue still occur, kindly share your pbix to me . Please upload your files to One Drive and share the link here.
Regards,
Frank
Hi @Anonymous,
If the issue still occur, kindly share your pbix to me . Please upload your files to One Drive and share the link here.
Regards,
Frank
what's the error exactly? What's the syntax for [Total Sales]?
is the Date table marked as Date table, with Date[Date] as key column? see here https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
is the join set to 1:many with single direction?
Hi Stachu,
Please se the screen shoot above
weird, syntax looks correct, but maybe you can try with this one:
LY Sales = CALCULATE ( [TotalSales], DATEADD ( 'Date'[Date], -1, YEAR ) )
I usually use https://www.daxformatter.com/ to verify syntax, maybe the spaces+capital letters will help
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |