Hello everyone, i’m having a troublesome issue. Please help me if you can!
My visual is kinda like this. However, for those with
, i need to use that text to calculate the value for
For example, BH10’s
budget_amount is calculated using budget from
Is it possible to write a calculated field that use the text from
formula field to calculate
budget_amount? If possible, please tell me how to do it. Thank you so much!
@Kuroha no. this is not possible
Hi @Kuroha - For each item, if you have a different formula, you can explore if else approach but this is not recommended, better to do this calculation at ETL or outside QS level.
Regards - Sanjeeb
So this isn’t possible at all? Ok, thanks everyone for answering me.
@Kuroha how many items do you have? If not to many you could create a measure for each item.
To bring it back in one column you would need another long ifelse to bring it all together.
But as @sanjeeb2022 said it would be more efficient to do it outside QS.
I need to use many filters so doing it outside QS may be impossible.
I’m also thinking about doing it like what you said. It might be long and tedious but i guess it’s possible.
maybe you can check that post as well
I’ll look into it, thank you.