Forum Discussion

AsadAliKhan's avatar
AsadAliKhan
Frequent Visitor
5 years ago

Closing Blance calculation

Hi All, I am new to DAX and trying to create a pivot report through Power BI, where month end closing balance is calculated by subtracting Fcast and adding Transit and On order quantity of respectiv...
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

In an MS Excel file, share your data and in another tab, show your expected result with your Excel formulas.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    I do not see any formulas in row 13 of the Result worksheet.  Also, why are so many sheets required in the workbook?

    • AsadAliKhan's avatar
      AsadAliKhan
      Frequent Visitor
      5 years ago

      Dear Ashih,

       

      I appreciate your interest, yes, there is no formula in row 13 for past month (Jul till Aug) as they are actual values while there is a formula from Sep onward (Column H) till last month.

      we have seperate sheets to inorporate everyone needs.

       

       

       

      Once again Thank you

      Asad

  • AsadAliKhan's avatar
    AsadAliKhan
    Frequent Visitor
    4 years ago

    Dear Ashish

     

    Hope you will be fine!

     

    Do you have any luck?

     

    Regards,

    Asad

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

      Sorry but i have not had the chance to look at this.  May be someone else can help you.