Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create multiple measures based on date

Hi, what I need to do is to create multiple measures based on date (14different measures/dates).   Example: //today's date MEASURE 'X'[XX] = CALCULATE ( [ Quantity], FILTER ( ALL ( 'Date' ),'...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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