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 everyone,
So I'm building a financial model in which I need a way to engineer a function similar to the Norm.Dist from excel. Currently I had a sql whizz of a colleague produce a very close estimater in a SQL query which feeds the CDF output to the model, however I would like if this could be done in M, DAX or worst case R (the latter is doable I think, but sticking to the first two would be ideal, since we're putting this in production)? It is used for the delta of a black-schole option pricing.
Anyone had success on this? The data set is big (+10m rows) if that changes anything
Thanks!
Mads
I do not know if what you are looking for is something like creating dynamic cumulative function to plot e.g., sales or uantity over time. If so I have placed an example PBIX file based on a dummy dataset here, I hope it helps.
Hi @Madsboegh,
Based on my research, I found an article about how to create a Dynamic BI Distribution Chart in PowerPivot using DAX.
And according to this article, there is an custom visual called Percentile Chart, or Cumulative Distribution Function (CDF) on Power BI Visual Gallery, is commonly used as a way to visualize the distribution of values in a dataset.
Could you go to check if it helps.
In addition, here is similar idea on Power BI Ideas about being able to run an analysis using normal distribution (bell curve) graphical representation. You can vote it up and add your comments there to improve Power BI on this feature.
Regards
Is there a way to add legends to percentile chart. Or is there a way to compare percentile chart for different catagories.
Hi @v-ljerr-msft,
Thanks for the reply, let me try and see if that helps. Will revert back to you
best,
Mads
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 |