Forum Discussion

peterso's avatar
peterso
Icon for Helper II rankHelper II
5 years ago
Solved

DAX help with strange distribution

Hi everyone,   Hoping you can assist with this distribution, i'll do my best to explain.    I'd like to distribute cost by month in such a way where it's cumulative(?) on the graph until the cost...
Need Help
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, peterso 

     

    You can do like this. Create a date table, don't create relationships, and create a measure to calculate the desired result.

    Like this:

    Date Table = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))
    Measure = SUMX(FILTER(ALL('Table'),[End Date]>MIN('Date Table'[Date])),[Cost])

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

peterso's avatar
peterso
Icon for Helper II rankHelper II
5 years ago

I reviewed those files earlier. They aren't relevant for this distribution. 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    peterso , please share in table format. Let me try. I need to get $16,000  for Jan 2018, that should be Jan 2021. As there is only one project is there on Jan 2018 ?

      • peterso's avatar
        peterso
        Icon for Helper II rankHelper II
        5 years ago

        Hi - I think maybe it would help to entirely ignore the start date.

         

        Essentially this distribution ignores the start date. It assumes all projects are started as as long as the end date is not past today's date.

         

        Once the end date for a project has passed, the project costs drop off.