Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My data is like that, plz help me to have
Ex-Factory Buyer Invoice No. Invoice Amount Realized Value Short Realized
16-Sep-19 | GPE Major | TAL-GPEMAJOR-2020-007 | $31,054.49 | $0.00 | |
16-Sep-19 | GPE Major | TAL-GPEMAJOR-2020-008 | $263.76 | $0.00 | |
27-Dec-19 | Mark Intl | TAL-MARK-DG-2020-009 | $114,455.04 | $0.00 | |
27-Dec-19 | Mark Intl | TAL-MARK-DG-2020-010 | $54,768.00 | $0.00 | |
14-Dec-20 | Mark Intl | TAL-MARK-DG-2020-065 | $70,425.60 | $70,150.60 | $275.00 |
14-Dec-20 | Aura | TAL-Aura-2020-066 | $93,216.56 | $93,171.56 | $45.00 |
17-Dec-20 | Aura | TAL-Aura-2020-067 | $15,245.53 | $14,664.68 | $580.85 |
7-Jan-21 | Mark Intl | TAL-MARK-DG-2021-003 | $ 65,733.41 | $ 64,143.75 | $1,589.66 |
31-Mar-21 | Cindrella | TAL-RRL-2021-021 | $ 22,816.75 | $ 22,762.63 | $54.12 |
31-Mar-21 | Cindrella | TAL-RRL-2021-022 | $ 3,642.60 | $ 3,588.48 | $54.12 |
27-Feb-21 | MAS | TAL-MAS-2021-024 | $ 22,113.68 | $ 21,973.68 | $140.00 |
Hi @rkarim ,
You first need to create a monthYear column in your data to aggregate values over.
I did this in Power Query by adding a new column with this formula:
Text.Combine({Text.Start(Date.MonthName([exFactory]), 3), Text.End(Text.From(Date.Year([exFactory])), 2)}, "-")
Once you apply that to the model, then you just need to create a basic percentage measure:
_shortRealised% =
DIVIDE(
SUM(aTable[shortRealised]),
SUM(aTable[realisedValue]),
0
)
Then you just need to put this measure into a visualisation with [buyer] and [monthYear] to get the monthly Short Realised percent for each month/buyer.
Pete
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.