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
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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
      5 years ago

      Dear Ashish

       

      Hope you will be fine!

       

      Do you have any luck?

       

      Regards,

      Asad

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

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