Forum Discussion

TejaManabotula's avatar
TejaManabotula
Regular Visitor
5 years ago

Integrating Power BI with COGNOS with added logic

Hi Everyone,   I just joined the PowerBI community would love to get your advice on a high-level to see how to approach the problem I'm facing.   I'm trying to automate a process where data is be...
Need Help
Tips and Tricks
TejaManabotula's avatar
TejaManabotula
Regular Visitor
5 years ago

Thank you for your response. Yes you are correct, I want to load the data from COGNOS into powerBI. Currently this data is being pulled from different sources and manipuated in Excel with VBA before creating a dashboard in Excel. I looked through the links you mentioned, but the logic I need is to create a data distributions using gammadist functions that are available in Excel ( https://docs.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.gammadist). Is there a way to do this in DAX? I can see there is a normdist function but cant find gamma dist. 

 

Thanks for your help.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi TejaManabotula ,

Base on my research, currently there is no the function GAMMA.DIST in DAX. You can raise one new idea ticket on Power BI Ideas site. Or here is one similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.

In addition, please review the last post in the following thread. Hope they  can bring some inspiration.

Gamma Distribution

Gamma

Best Regards