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 would like to know which formula I must use in order to distribute the amount (of an order) between two dates, the date of start and the end date of the service.
The idea is that having an amount and the start and end date, because you know what amount I will bill each month.
Example:
Order 1: 100,000 euros; start 1/11/2020 and end 1/11/2021
although I've seen some post with similar information, I haven't been able to apply it.
Thank you
Solved! Go to Solution.
@nuriac , Check if the attachment can help you.
@nuriac , Check if the attachment can help you.
It puts the correct values to me, but they only come out in one month, for example if an order lasts from January to May, I only get values for that order in the month of January. The January value is correct, but I lack data in the other months.
Solved.
It had related the calendar to the start date and therefore did not distribute correctly between the months. Removing the relationship has been perfect.
Thank you
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.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |