Forum Discussion

Scholes's avatar
Scholes
Frequent Visitor
2 years ago
Solved

Average value balance sheet

Hello,   I have a measure which calculates the purchase value YTD which relates to the accumulated balance sheet. Now I want to calculate the average value per year for this measure. In this case ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Scholes 

     

    Since I can't restore your data, I can't give a specific formula. To better help you, can you provide sample data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

     

    Here's my current suggestion for your reference:

     

    You can start by figuring out how many months correspond to each other in the balance sheet, and then use the Purchase Value YTD with the figured answer.

     

    Best Regards,
    Yulia Xu

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Scholes 

 

Since I can't restore your data, I can't give a specific formula. To better help you, can you provide sample data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Here's my current suggestion for your reference:

 

You can start by figuring out how many months correspond to each other in the balance sheet, and then use the Purchase Value YTD with the figured answer.

 

Best Regards,
Yulia Xu

 

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