Cumulative Normal Distribution (CDF) Function for black-scholes

[Madsboegh]

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

[tschris]

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.

[v-ljerr-msft]

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

[sm_tm]

Is there a way to add legends to percentile chart. Or is there a way to compare percentile chart for different catagories.

[Madsboegh]

Hi @v-ljerr-msft,

Thanks for the reply, let me try and see if that helps. Will revert back to you

best,
Mads