Previous Month Value

[#1]

Hi Friends,

We have a requirement to show month-3 value (Ex: If June is selected then we want to show Mar month value). Below expressions are used and value is displayed in a separate column whereas requirement is this value need to be displayed in the same column as other measures. Attaching the screenshot for reference.

sum({<MonthYear={'$(vYear3)'},Month_Name=>}Revenue)

vYear3= Date(AddMonths(max(Date),-3),'MMM YYYY')

2912 value is correct but we require it in June column instead of March column(which is getting created as a separate column.

Thanks in Advance,

Siva Srinivas.

[Anonymous]

Hello,

The issue is about your dimension. It should work without it.

It is normal because QV cannot show a dimension's value under another value.

BR

Serhan

[Anonymous]

You need to write different expression for each column.

BR

Serhan