Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
is this correct?
No of Crimes Last Year = CALCULATE([No Of Crimes], SAMEPERIODLASTYEAR('Date'[Date].[Date]))
this is the result i am getting
Proud to be a Super User!
Hi @vanessafvg
Do you have a calendar table called Date? and is it related ok to your table?
Otherwise try
No of Crimes Last Year = CALCULATE([No Of Crimes], SAMEPERIODLASTYEAR('Date'[Date]))
and make sure you use a field from your Calendar table in the axis if your visual
ps yes i used a calendar table
Proud to be a Super User!
Is [No of Crimes] a measure? If so can you post the code here? There may be something in that code that is preventing the new formula from working 100% correct.
if i place it on the matrix depending on how i am looking at it it shows the right result but it seems like it could be complex in terms of displaying, how do you usually do that and it only seems to show on the new matrix.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |