select the previous month directly

[Phara]

Hello,

I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period, as an example, we're in May, I want to select April.

Any expression for that please?

Thank you so much

[marksouzacosta]

There are different solutions for this problem and the best one depends on how you want your app to behave.

Solution 1

In your Load Script, add a new field called [Previous Period] and calculate it according to the [Period Exercise]. This will create a straight association between your Exercise and Previous periods.

Solution 2

You can calculate the desired Previous Period and use in your measures using Set Analysis. This is very flexible but harder to implement and it does not affect all measures of your dashboard (you'll have to make the same adjustment on every measure that needs the same rules)

Please let us know what looks more like what you are looking for so we can try to figure out the code for that.

[Phara · Accepted solution]

Hello @marksouzacosta 

I'd like an expression with the solution # 1 please

Thanks!