Forum Discussion

Anonymous's avatar
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...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
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's avatar
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's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    I do not have that file anymore.  Describe the question and show the expected result.