Expression logic

[khadar]

Hi Experts,

Need small help from you. Actually I am calculating a value by Multiplying some columns in front end . for example(A*B) to get the result C. Now Business asks is till SEP2022 data calculation should be the same which is A*B and and after sep-2022 the calculation would be D*B to get value of C.

I have Month, year filters on my dashboard can you we built something like MOnth& year >oct-2022 the calculation is  D*B else A*B?

can you help me with expression pls ?

[Vegar]

You really should consider having some kind of date in your data model. It does not need to be a visible field i the dashboard, but It helps when trying to control a measure using set analysis.

If you have or can create a date field, let's assume It is named datefield, then you should be able to do something like this.

Sum({<[datefield]*={"<$(=makedate(2022,10))">}A*B) + Sum({<[datefield]*={">=$(=makedate(2022,10))">}D*B)