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.
Hello!
I am currently working a base in power bi where I have a monthly balance column for each client, so what I want to know how much each client of the base has amortized every month.
My problem is that the client is repeat in all the months of the year in the same column, if the client repeats in a column per month could do in the simple way subtract but I do not know if any of you could provide me with a solution.
thanks in advance.
Solved! Go to Solution.
Hi @DMinero,
Not sure how you information is setup but you can do a measure like this:
Amortized = TOTALMTD ( SUM ( Table[Value] ), Calendar[Date] ) - TOTALMTD ( SUM ( Table[Value] ), DATEADD ( Calendar[Date], -1, MONTH ) )
If you add this to your table with customer name and month you should have what you need change the columns to the ones on your model.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @DMinero,
Not sure how you information is setup but you can do a measure like this:
Amortized = TOTALMTD ( SUM ( Table[Value] ), Calendar[Date] ) - TOTALMTD ( SUM ( Table[Value] ), DATEADD ( Calendar[Date], -1, MONTH ) )
If you add this to your table with customer name and month you should have what you need change the columns to the ones on your model.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthnks to anwers, just a quick question calendar is a table ?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI MFelix Sorry for bothering I do the calculation as indicated, but it only subtracted 1 dollar instead of subtracting the amount of the previous month.
Could you tell me if I can do two simple columns:
1. Column MTD, which I already have
2. Column previous month
In this way, I could proceed and just make a simple subtraction.
Thnks in advance.
Hi @DMinero,
If you do the split of my formula you have two measures:
Total MTD =TOTALMTD ( SUM ( Table[Value] ), Calendar[Date] ) Total PY MTD = TOTALMTD ( SUM ( Table[Value] ), DATEADD ( Calendar[Date], -1, MONTH ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |