Create a new table with a column that conditionally replaces values

[saddas]

I have a data set that includes one column: Table 1: Qty.

Here is a link to the data set: https://www.dropbox.com/sh/9g6uvptyzazfl0u/AAAsElP-PuQxtnJOHCa-BGLWa?dl=0

I would like to use DAX to create a new table that returns all the values from the original table, except that it should calculate the 0.95 percentile and replace all values that exceed that value by the 0.95 percentile

For example, in my dataset, the 0.95 percentile is as follows:

PERCENTILEX.INC( 'Table 1', 'Table 1'[Qty] * 1.0, 0.95 ) = 6.5. Any values above 6.5 (in this case there is a value of 8.0 that should be replaced by 6.5.

Appreciate help with this. Thanks.

[ALLUREAN · Accepted solution]

Hi, @saddas 

Please check this example:

https://www.dropbox.com/s/qz83sf9yhtkiufw/test%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/