Forum Discussion
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
- AnonymousNot applicable
i dont know how to attach files
I can put a video ??
- AnonymousNot 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
Helper 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
Community 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