cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Create Power Bi report from 2 SharePoint List

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

1 ACCEPTED SOLUTION
Community Support

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

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.

3 REPLIES 3
Community Support

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

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.

New Member

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

Super User

@kghimire , 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"))