Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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.
Will this get all the column with same invoice id on both list with Status = approved
@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"))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
108 | |
108 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |