Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago

P&L Help +- & Sort

Hi community, Two questions I'm having trouble with I have a financial statement the Description in the table come from an Dim account The amount comes from the FACT table Everything is connected...
Need Help
netanel's avatar
netanel
Post Prodigy
4 years ago

Sori,
updated

lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

 

Unfortunately your sample data is still not in a usable shape.

 

You also seem to expect to be able to use data from different levels of the hierarchy.  While that is possible it will make the measure very complex as you will have to account for all hierarchy level scenarios separately to avoid double counting. You may want to rethink that process.

  • netanel's avatar
    netanel
    Post Prodigy
    4 years ago

    Hi lbendlin 

    Sorry for the delay and the mess
    I really didn't specify the data a bit because I thought I would get a general direction
    But thanks for the answer and the desire to help
    I have attached in the link both a PBIX file and a detailed Excel file that contains my example
    Unfortunately, the data is sensitive and it is difficult for me to prepare an example case
    I will send you another message regarding this matter
    Beyond that, I think that the sample data will be able to give a clearer direction this time

     

    https://1drv.ms/f/s!AonyYI-TdspHgUhwngZ6OKvpnSsc

    expected outcome:

    What you see in the Visual sheet in Excel


    Thanks!