Forum Discussion

Neustupa2001's avatar
Neustupa2001
Frequent Visitor
9 years ago

DAX - Graph budget changes over time

I'm struggling to graph budget amount changes over time.  The data that I have looks like:   ProjectID   |   ActivityID  |   Budget   |   StartDate   |   LastUpdateDate   |  IsCurrent 1           ...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Neustupa2001,

 

Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.

Best Regards!
Dale

  • Neustupa2001's avatar
    Neustupa2001
    Frequent Visitor
    9 years ago

    I'm sorry for taking so long to get back to this.  We have been trying to solve this with our data model by putting a daily value in there but I don't think that I going to be sustainable due to hundreds of thousands of records a day being inserted.

     

    I believe I'm overcomplicating what I'm trying to accomplish here.  The above is a dumbed down version of what I'm trying to do.  Instead what I'm getting is