Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have de next calculated table.
That table is generated with the next measure.
The "Mode" column was not grouped by "master_product_id" and by "related year_week"
I thought use GROUPBY but it seems that it is not compatible with MEDIANX
I would like to know if there is a way to do this.
Solved! Go to Solution.
@Yeztrom , This will take complete column, Try like
If needed use add columns to add the below column
VAR _VW_Prices_Mode_Clear =
SUMMARIZE(
_VW_Prices_Mode,
[master_product_id],
[related year_week],
"price",[product_current_price]
)
New column = MEDIANX(filter(Table, [master_product_id] = earlier([master_product_id]) && [related year_week] = earlier([related year_week]) ), [Price])
or
New column = MEDIANX(filter(Table, [related year_week] = earlier([related year_week]) ), [Price])
@Yeztrom , This will take complete column, Try like
If needed use add columns to add the below column
VAR _VW_Prices_Mode_Clear =
SUMMARIZE(
_VW_Prices_Mode,
[master_product_id],
[related year_week],
"price",[product_current_price]
)
New column = MEDIANX(filter(Table, [master_product_id] = earlier([master_product_id]) && [related year_week] = earlier([related year_week]) ), [Price])
or
New column = MEDIANX(filter(Table, [related year_week] = earlier([related year_week]) ), [Price])
Thanks,
The solution was:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |