Hello,
I don't think you can make the output of RelativePeriod into a string, sorry.
For what it is worth, you can apply display rules to aggregated measure values. So you could highlight the positive/negative differences.
A workaround that is sometimes suggested when working with aggregated values is to create an aggregated data source to store the aggregated values.
For the offset parameter, I believe you could do something very inelegant like this:
IF ( 'Param'p = 1 ) RETURN <RelativePeriod expression with offset 1> ELSE IF ('Param'p =2 )
RETURN <RelativePeriod expression with offset 2>
ELSE IF ('Param'p =3 )
RETURN <RelativePeriod expression with offset 3>
And so on.
You could give it a try.
Let us know if that helps.
Thanks,
Sam
... View more