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.
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:
Appreciate help with this. Thanks.
Solved! Go to 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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |