Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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)