Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HOW TO CALCULATE INSTALLED BASE (MOVIL)

Hello  

 

I need to calculate the installed base of hardware  calculating the % to actual time but when i go backward its not working , (sory for mi bad english ) 

 

I can attach the file u need to convert to dax expression its made in excel and i have to do manually (for each client in each modelo in each month ) and i like to know how to automatize the process , i also try to make the expression by miself and the final month is the same  , but goin backward its not (thats because the expression i mada its not mobile across the time) 

 

In fine original  is the excel way made by hand every month with every client 

 

 

in the second file 

 

i have the file i made with the expression but if you see , only the last month is the same , (the hw installed base in jun 2018  is the same in excel way and in dax way , but may 2018 is not the same ) 

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    i dont know how to attach files 

     

    I can put a video ??

  • Anonymous's avatar
    Anonymous
    Not applicable

    I attach the photo with the measure im trying to do (sory for the format but wen i go to dax formatter its give me an error)

     

     

       

    • Jeffrey_VC's avatar
      Jeffrey_VC
      Icon for Helper III rankHelper III

      Hi everyone,
      Is there a solution about this issue? i have a similar issue with installed base of our systems.

      Thnx.

      Regards, Jeffrey

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous

    You could upload your file to OneDrive, then share the link with me here.

    Or if your file need privacy protection, you could send a private message to me along with your file.

     

    Best Regards

    Maggie