Forum Discussion

zahlenschubser's avatar
zahlenschubser
Icon for Helper IV rankHelper IV
3 years ago

Turn an imported hierarchy into a mapping table

Hi there!   I have another rather exotic problem.   In the reporting platform we use we have a hierarchial structure, but I cannot directly export the relationships, so I cannot build a BI report...
Need Help
zahlenschubser's avatar
zahlenschubser
Icon for Helper IV rankHelper IV
3 years ago

Visually it works now, but what I would like to do is appply that hierarchy to the accounts now (and the exported values / other data on them).

 

But as the accounts don't have a 1:1 connection (income statement, NWC etc.) I cannot easily map that hierarchy to the accounts for that.

BiNavPete's avatar
BiNavPete
Icon for Resolver III rankResolver III
3 years ago

HI zahlenschubser 

As I said in earlier post the subject of mapping accounts/GL values to Power BI is a very complex subject and without a data model difficult to advise. But even then the DAX involved can be quite complex.

Please refer to earlier post to see links to power bi financials guidance.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181