Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Grouping Field Parameter

Hello everyone, I have a field parameter that looks like this. time_field = {     ("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0),     ("etl_update_time_month", NAME...
  • Idrissshatila's avatar
    1 year ago

    Hello Anonymous ,

     

    the grouping will be after the last parameter shich is the sorting one as the follows

    time_field = {
    ("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "group 1"),
    ("etl_update_time_month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "group 1"),
    ("etl_update_time_day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "group 1"),
    ("etl_update_time_hour", NAMEOF('mvpmonitoring'[update_time_hours]), 0, "group 1"),
    ("etl_insert_time", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "group 2"),
    ("etl_insert_time_month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "group 2"),
    ("etl_insert_time_day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "group 2"),
    ("etl_insert_time_hour", NAMEOF('mvpmonitoring'[insert_time_hours]), 1, "group 2"),
    ("etl_source_time", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "group 3"),
    ("etl_source_time_month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "group 3"),
    ("etl_source_time_day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "group 3"),
    ("etl_source_time_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2, "group 3")
    }