Create Power Bi report from 2 SharePoint List

[Anonymous]

I have 2 list on SPO 

Invoice with following field
Invoice Number : - Number
Payment : Amount

Status : Approved / Not Approved 

Break Down 

Invoice number : lookup from Invoice

and other columns 

I need to generate reports based on Invoice number from Invoice list equal to Break down invoice number and Status is Approved . 

I am completly new in Powe rbi so if anyone can help me how to 

[Anonymous · Accepted solution]

Hi @Anonymous

Based on your description, I created these data and established a one-to-one relationship for them.

You can create measures and write expressions.

Measure =
CALCULATE(MAX('Invoice'[Invoice Number]),'Invoice'[Invoice Number] IN VALUES('Table'[Invoice number]) && 'Invoice'[Status ] = "Approved")

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Will this get all the column with same invoice id on both list with Status = approved

[amitchandak]

@Anonymous , You can join both tables on the Invoice number and then use status as filter/slicer

or can have a measure like

calculate(Sum(Table2[Value]), filter(Table1, Table1[Status] = "Approved"))