Distribute values to FY-Q and Months

[Amardeep100115]

Hi there,

I am seeking assistance from the Power BI Super Users in the Power BI Community. I wish to create a view similar to the one in the Result sheet, but my current attempts have not produced matching data. I would appreciate help with a Measure or Power Query solution. Specifically, I need help with the following:
1. **Annual Gross ICE Savings**: Measure or Power Query solution (refer to Sheet 1)
2. **Annual Gross Cash Savings**: Measure or Power Query solution (refer to Sheet 1)
3. **Cost to Execute FY24**: Measure or Power Query solution (refer to Result Sheet 1) - This should change based on the FY selection in the slicer and a constant.
4. **View from Column H to Column BV** The data is available for access via the shared link.

Thank you for your assistance!

Reference Video 

Sample Data 

[Anonymous]

Hi @Amardeep100115 ,

You can use the Matrix visual object to place months on rows and place mesures in the value area. You can unpivot other columns in Power Query to create more dynamic models that can be sliced by different time periods or categories.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amardeep100115]

Hi @Anonymous 

In the monthly view, I noticed some negative values that shouldn't be there.

I've prepared the data, but the quarterly view isn't displaying correctly. Could you please create view in shared BI file similer as in excel sheet and help me on this? Your assistance would be greatly appreciated.

Thanks!