Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Calculate median from calculated column

Hello, good afternoon I have the following calculated table This table corresponds to the calculation of a fashion however when it is the case that it has more than one fashion I need to c...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    After searching the internet I could make the solution which is as follows:

    WHERE _VW_Prices_Mode_Clear =
    SUMMARIZE(
    _VW_Prices_Mode,
    [master_product_id],
    [related year_week],
    "Mode",MEDIANX(FILTER(_VW_Prices_Mode, [master_product_id] = EARLIER([master_product_id]) && [related year_week] = EARLIER([related year_week]) ), [product_current_price])
    )
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

After searching the internet I could make the solution which is as follows:

WHERE _VW_Prices_Mode_Clear =
SUMMARIZE(
_VW_Prices_Mode,
[master_product_id],
[related year_week],
"Mode",MEDIANX(FILTER(_VW_Prices_Mode, [master_product_id] = EARLIER([master_product_id]) && [related year_week] = EARLIER([related year_week]) ), [product_current_price])
)