Forum Discussion
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
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.
3 Replies
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"))
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.
