Hi community, I have a sample dataset with three columns "date,", "amount" and "cost center 39201",
I have created three measures(cost center 39202, 39203, and 39204) base on the sum of the amount(39201) * some percentage (please see my logic picture),
The percentages are not always fixed, it will be changing monthly base on my boss gives me the updated excel info at the end of month/begin of month, and we don't want the amount that already calculated by old percentage affected by new percentage.
could you give me some ideas? thank you
logic:
if I hard coded the measure:
final display dashboard will be:
2 answers
the percentage value will be in another excel work file
