For my model I have constants to be applied such as projected inflation rate, depreciation years, and other values to be set by users as what-if options. There are too many variations the users want to create disconnected tables - e.g. listing every inflation rate by hundredths of a percent - resulting in huge lookup tables for 12-15 constants, so it's simpler to have a default table with values for each constant that I import into the model with Power Query.
Once the table is loaded however, I'm sure there must be a simpler way than I use to extract the value the user has entered so I can use it in calculations... I essentially do
then I can use the measure [Inflation Rate] in later formulas. This seems so convoluted that I'm hoping there's something blindingly obvious that I've missed.
Once the table is loaded however, I'm sure there must be a simpler way than I use to extract the value the user has entered so I can use it in calculations... I essentially do
Code:
Inflation Rate:= CALCULATE(MAX(DefaultTable[Value]), DefaultTable[Lookup] = "Inflation Rate")