Compute COGS in Powerbi

[Rahp]

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). 

[v-venuppu]

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.

[v-venuppu]

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]

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 · Accepted solution]

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 .

[alish_b]

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.