11-20-2023 09:02 AM
Hi All-
We are trying to create a BI Viewer to compare Current v Previous Qtr OPEX.
We look at the end date (only two end dates possible of course) to create a Current QTR measure (max end date) as below. However, I can't seem to get the syntax for the measure correct. Not sure what I am missing which is generating the error below: A Summary Expression is Expected
11-21-2023 12:01 PM - edited 11-21-2023 12:03 PM
You're comparing a string or date [EndDate] with the True/false returned by [Scenario] == 'Actual'. I suspect you want something more like
If(
([EndDate] == max([EndDate]) )
and ([Scenario] == 'Actual') ,
[Amount], 0)
This said, I don't remember if that Max() operations will actually work like you expect it to, nor whether you can actually use == like that.
11-27-2023 03:45 PM
Thank you for the reply ... I will attempt a different approach to group the data.