Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Amardeep100115
Post Prodigy
Post Prodigy

Need help on distributing values by month and quarter

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 

Amardeep Bhingardeve
2 REPLIES 2
v-xuxinyi-msft
Community Support
Community Support

Hi @Amardeep100115 

 

I can't open Video's link due to Security Policy. I don't really understand what you need, could you please explain it in conjunction with screenshots? It would be nice if you could explain the calculation process. Thank you for your time and efforts in advance.

 

Best Regards,
Yulia Xu

Hi @v-xuxinyi-msft

Please refer excel result sheet for more information, i would like to have similer view into Power Bi with same view and values 

Amardeep Bhingardeve

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.