Forum Discussion
Create multiple measures based on date
HI Anonymous,
In fact, my formula can generate multiple results based on the current parameter value if you use the parameter table field on the matrix column field.
AFAIK, current power bi desktop does not include features to bulk create multiple measures, so you need to manually create each of them instead of creating multiple measures at the same time.Regards,
Xiaoxin Sheng
Hi Anonymous,
I'd like to suggest you create a parameter table with numeric values from 0 to 13, then you can use this field as the axis of your visual and use the Dax expression to extract the current parameter value for dynamic calculation.
New table:
ParaTable =
GENERATESERIES ( 0, 13, 1 )Measure:
Dynamic quantity =
VAR selectedPara =
MAX ( ParaTable[Values] )
RETURN
CALCULATE (
[ Quantity],
FILTER ( ALL ( 'Date' ), 'Date'[X Date] = TODAY () + selectedPara )
)Regards,
Xiaoxin Sheng
Thank you for your advice, but I need all 14measures, just looking for a solution to create them all in one move (loop) :). All 14measures are visible in the final table.
HI Anonymous,
In fact, my formula can generate multiple results based on the current parameter value if you use the parameter table field on the matrix column field.
AFAIK, current power bi desktop does not include features to bulk create multiple measures, so you need to manually create each of them instead of creating multiple measures at the same time.Regards,
Xiaoxin Sheng