Hey guys.
I'm currently developing some financial reports and I have two tables: Financial_Fact (all events that envolve money in or out) and Financial_Indicators (is my dimension table and got everything about my financial indicators).
There are two types of financial indicators:
- The ones that come directly from my data, so in order to calculate them I just need to sum all the lines that got the respective code of the indicator.
- The ones that are calculated via the ones mentionated here above.
So in order to calculate this "harder" ones this is what I want to do:
I would like to add a column to the "Financial Indicators" table where I would put the respective DAX formula of the indicator.
The problem that persists is to find out some way to bring that formula and apply it. I can only bring the formula as text format. I'm just missing how to aaply each peace of text to become a real formula in my dashboards. Something like an Apply() function.
Does anyone of you got an experience like this one or has any idea how I could solve this question?
Tks for reading !!
