Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
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
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |