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've manage to figure out meanwhile out to do.
Thanks for the help,
JR
@jppuam , Create a table using generateseries
months= generateseries(1,120,1)
new table=Filter(generate(months,table), month[value]<= Table[Month])
Add columns with divided values with no of month
Same example with dates
How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
hello amitchandak,
i dont quite understand. I dont have dates, can you explain again pls ?
see this example:
ProductCode monthsContract value
Z0001 25 1000
Z0002 36 1550
Z0003 48 1800
i want to generate the month value per product, but the product Z0001 only goes to the month 25, and the second to month 36 and so one. can you see it please ?
thanks,
JR
thanks,
JR
HI @jppuam,
Did the value field mean the cumulative value between different records?
If that is the case, you can get the total value based on the current and previous values. Then you can calculate it with the month number diff to get the monthly value.
If not, did these values mean the month value from the current one till the new month value? (e.g. month 25~35: 1000, month 36~47:1550)
For this scenario, you can try to create a new table with all month numbers and 'product code' then look up the last record with value to fill up the records without values.
Regards,
Xiaoxin Sheng
Hello,
i've manage to figure out meanwhile out to do.
Thanks for the help,
JR
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |