Forum Discussion

jacopo19o1's avatar
jacopo19o1
New Member
3 years ago

How can I monthlyize a value

Hello everybody,

 

Before explaining the problem, let me explain what it is.

 

In a nutshell I have sales with total values ​​and duration. Example sale A for a total of 100k over 5 months. So I would have an income of 20k a month.

 

I would like to create a table where on the y axis I have the sales ids, on the x axis the months, and as values ​​the monthly sales that are repeated for the entire duration of the single sale. In doing so I could simulate the total revenues of the month from different sales. I don't know if I explained myself.

 

the problem is that there are no cycles on power bi and therefore I don't know/I don't know the formula to create this table.

 

The only useful formula I've found is this:

Dateisinperiod which creates me a date vector with the actual months of sales.

1 Reply