Forum Discussion

Anonymous

Not applicable

6 years ago

How to spread value between two dates ?

Hi everyone, I need some help on my Power BI. I am trying to spread the value of a project over several months, to know exactly how much I will have to produce every month. For exemple, if I...

Super User

6 years ago

Hi,

I think your calculation of amount per day is incorrect. For the first project, it should be 100000/121 = 826.4463 and not 100000/120=833.3333. You may download my PBI file from here.

Hope this helps.

EdwardWer
Frequent Visitor
2 years ago
Ashish:

Hello. I could not download the file with the link you provided.
Can you please advise what change you made to the DAX Measure "MonthAmount"?

Thanks,
Edward
- Ashish_Mathur
  Super User
  2 years ago
  Hi,
  
  I do not have that file anymore. Describe the question and show the expected result.
EdwardWer
Frequent Visitor
2 years ago
Ashish:

The image you posted, shown below, had the correct "Total values".

The values in the file uploaded by someone else (URL below) had incorrect Total values, please see the screen shot below.

https://community.fabric.microsoft.com/oxcrx34285/attachments/oxcrx34285/power-bi-designer/439517/1/How-to-spread-value-between-two-dates.pbix

I was curious how you corrected this.

Thanks,
Edward
- Ashish_Mathur
  Super User
  2 years ago
  Hi,
  
  I cannot understand your question. Offer a simple explanation and show the expected result.

Related content