Forum Discussion

Almantas32's avatar
Almantas32
Icon for Helper II rankHelper II
6 years ago

Dynamic Tracking of Open Orders by Date

Dear Cummunity inhabitats, 

 

I'm sure there is an answer for this somewhere, but I can't seem to google it correctly. 

 

We have a measure of Open orders Calculate(COUNT(Deals[ID]); Deals[Won Status] = "open"

The Deals Tabel has a Creation Date Column, and A Closing Date when the Order is closed, and won status changes to "won" or "lost".

Open orders measure is not connected to any date column, but just a show how many open orders are there Today. We want to have a history of Open orders by day:

 
 

, but our CRM does not store history of open orders.

 

Is there a way how to store daily results of Open Orders with Power Bi? Or should I develop this on our CRM?

 

Thanks!

Need Help

4 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Almantas32 , 

    I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

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

    • Almantas32's avatar
      Almantas32
      Icon for Helper II rankHelper II
      6 years ago

      Thank you very mutch for the reply. I narrowed down my question to this: 

       

      If I calculate something in Power Bi, can I save a particular days result and use it for dynamic reporting?

       

      I. e. Every day I make a calculation of Open Orders on that day (but it is not connected to any date column). Can Power Bi save and store today's result to use for later dynamic analytics? 

       

      I heard that you can do something like that with R code if I am not mistaken.