Set expression with condition

[prma7799]

Dear All,

We have PTS value from Jul’17 to till date prior to that we have Sales bonus value( from beginning to 30-06-2017)

Now my requirement is If user select financial year 18-19 and month apr to jun 

Then it will display Last year bonus value (Apr-17 to Jun-17)

And if user select 18-19 and month July   then it will display  last year PTS value (Jul-17)

[thevingo]

have you tried using triggers

Or simply create another measure in the script with Last year bonus value upto last month i.e. upto June18 & last year PTS value for July18 (Current month) then use this measure.

[sunny_talwar]

I guess this is the table you are talking about

What is the numerical output you are looking to get in the above sample?