Accounts Payable Paid

Question

I have a dim table that includes 50 vendor#/vendor names that I want to keep track of and see if we have paid their invoice each month. I have that dim table merged to a fact table based on vendor# that includes paid amount, date of paid amt, description of paid amt. I'd like to use PowerBi and be able to filter on a month and then it list the vendors that haven't paid for that month and those that have paid for that month. I need help with the DAX formula to do this.&nbsp;

amitchandak · Answer

cvill24&nbsp;I think it requires more information on tables, they column they have etc. But except can helphttps://docs.microsoft.com/en-us/dax/except-function-dax&nbsp;Assume we have only 50 vendors in vendor and all need to payed every month. Take vendors from dim and subtract vendors coming from payment. As payment will have the filter from the page. summarize should take itexcept(distinct(All(Vendor[ID])),summarize(payment,payement[vendor_id])&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin

ashish_mathur · Answer

Hi,
Share some data and show the expected result.

cvill24 · Answer

Vendors to keep Track of: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Vendor # &nbsp;&nbsp; Vendor Name1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Pepsi2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; McDonalds3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Walmart&nbsp;Transactions TableVendor# &nbsp; &nbsp;&nbsp; Vendor Name &nbsp; &nbsp;&nbsp; Date Paid &nbsp; &nbsp;&nbsp; Paid Amt6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Amazon &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1-15-20 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 501 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Pepsi &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1-16-20 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 107 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Target &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1-16-20 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 203 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Walmart &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1-20-20 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1008 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Westar &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1-20-20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp;I'd like to filter on January and it showVendor # Vendor Name &nbsp; &nbsp; Status1 Pepsi &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Paid &nbsp; &nbsp;2 McDonalds &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Not Paid3 Walmart &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Paid&nbsp;

ashish_mathur · Answer

Hi,
You may download my PBI file from here.
Hope this helps.

&nbsp;

Forum Discussion

Accounts Payable Paid

4 Replies

Related content

Accounts Payable past and current

Community account support

Import all code from Trial Account to a Paid account

Power BI Account Blocked

Tabular Editor Free and Paid