Hello All,
I am looking for some general guidance. I need to create a financial statement, but I am struggling to get my data structured approprately to output what I need. I am working with one datasource with a relationship to a date table, but I will have 2 other files containing other necessary data for this report. I have added my sample data with my desired output. I am trying to do this in a matrix so that I can dynamically change my columns to reflect selected date fields.
Current Data:
| Location | Product Number | Date | Amount |
Desired Output:
| Location 1 | Primary Month | | Secondary Month | | 2 Month Total | |
| | Value | % of prev value | Value | % of prev value | Value | % of prev value |
| Amount 1 | | | | | | |
| Amount 2 | | | | | | |
| Amount 3 | | | | | | |
| Net | | | | | | |
| | | | | | | |
| Amount 4 | | | | | | |
| Amount 5 | | | | | | |
| Amount 6 | | | | | | |
| Net | | | | | | |
How can i structure my data to output like this? A calculated table? What would that look like?
I have manually created this in Power BI report builder with all my measures, but I want to do this in Power BI as well so we can filter at any moment on web and run reports. Any help would be appreciated!
