Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Missing supplier invoices

Dear Community Members, My Name is Sayed and working as an Account Payable for a Pharma Industry. I am completey new with Power BI. I receive invoices from our suppliers every month. I have generat...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Idrissshatila, 

Thank you for the provided solution.

Let's explain my question another way around.

I don't wanna put anything manually.

I set a date Range (ex. 05.2023 - 04.2023).

My Visual should look for Vendor based on given date and give me below Information.

I wanna get two Reports.

1. A list of Supplier with invoice amounts per month.

2. A list of Supplier with missing amounts per month. -> based on given date.

 

I am sure there is a way to get to such information. Since I am new with Power BI, I just have to search and search and search.

 

Regards,

Sayed

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Anonymous ,

 

Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.

Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

 

Show what you expect based on the provided data.

For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150