Forum Discussion
BlueSky
Helper I
6 years agoHow to make this DAX code more efficient (less duplication).
The following table expression is working fine (it's to create exponential growth data for the Covid-19 virus, based on the virus doubling every x days.). I'm still learning PowerBI and I'm st...
- Anonymous6 years ago
EVALUATE var __rates = SELECTCOLUMNS( {.5, 0.333, 0.25, 0.2}, "GrowthRate", [Value] ) var __upperLimit = 10 var __output = GENERATE( __rates, var __currentRate = [GrowthRate] return ADDCOLUMNS( GENERATESERIES(1, __upperLimit, __currentRate ), "Days", round( [Value] / __currentRate + 1, 0), "Deaths", round(__upperLimit * POWER(2, [Value] ), 0 ), "Country", COMBINEVALUES( " ", // delimiter "Every", round(1 / __currentrate, 0), "days" ), "KeyFactToDimStartEnd", COMBINEVALUES( " ", "Every", round(1 / __currentrate, 0), "days", "-", round( [Value] / __currentRate + 1, 0 ) ) ) ) return __outputBest
D
Mariusz
Community Champion
6 years agoHi BlueSky
The below article will explain how to use variebles in DAX
https://www.sqlbi.com/articles/variables-in-dax/
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
BlueSky
Helper I
6 years agoI've already seen that article, the purpose of posting on here was for someone to help apply the theory in practice, which I've not been able to do without generating errors.