Forum Discussion

Rahp's avatar
Rahp
Helper I
1 year ago
Solved

Compute COGS in Powerbi

The tally data is linked with Powerbi via SQL 
constrcuting the real time P&L 
Stuck in computing COGS as , in our premise the Opening Stock & closing Stock are direclty entered in tally. 
So from which table the entry /value of Stock in hand major group will be secure 
additionally the format of P&L should also look like 
COGS
   Op. Stock
+Purchase 
-Clo.Stock 
The end goal is to have MOM real time P&L in the own define structure (mapping required with owned structure). 

Tutorial Requests
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Rahp ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you alish_b for the prompt response.

    I have created a sample PBIX file by using sample data.Please go through the attached PBIX file for your reference.

    If this doesn't help kindly share the sample data and expected output as suggested by alish_b .

5 Replies

  • alish_b's avatar
    alish_b
    Super User
    1 year ago

    Hello Rahp ,

     

    Please provide sample data (that can be copied and not in image format) and perhaps a sketch of the expected outcome. It would help others to understand your requirement better and provide you with helpful suggestions.

     

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Rahp ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you alish_b for the prompt response.

    I have created a sample PBIX file by using sample data.Please go through the attached PBIX file for your reference.

    If this doesn't help kindly share the sample data and expected output as suggested by alish_b .

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Rahp ,

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Rahp ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    11 months ago

    Hi Rahp ,

    I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

    Thank you.