Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola amigos Expertos en Dax !!
Necesito de su ayuda.
Tengo una base de datos con 3 columnas principales.
Fecha, Empresa, USD.
Necesito generar una tabla nueva o una medida para calcular el Market Share. Primero como nosotros lo calculamos es de 12 meses moviles al último mes. Me explico: Si estoy en abil 2021, el Valor Total sera el acumulado desde abril 2020 hasta marzo 2021 (12 meses), y así sucesivamente. En base a ese monto total, calculamos el Market Share.
Favor su ayuda, no logro llegar a armar una grafica que colocando en el eje "x" los meses, me muestre el acumulado, solo muestra el monto de ese mes.
Infinitas gracias por su ayuda.
Solved! Go to Solution.
@Anonymous Thank you very much for your support, the solution has been correct.
Additionally. Do you have a solution for the column "MonthID"?, Do you have any ideas or proposals? I checked in the Forum and I have not found anything that can be automatic. At the moment I have incorporated a manual table that makes the relation giving a "MonthID" to the Calendar Table.
Hello @Anonymous
The file is in your trash, please upload again.
Thanks !
Hello @Anonymous
I've updated the link. Please check in the previous message.
Very thank you !
Hello @Anonymous
Have you checked the file? Is it working as expected?
Yes, please mark the solution so it will help others.
Hi @Anonymous
I mark the solution, thanks.
But, i need your help!. When i try to make a new mesure, it calculate the Market Share for only one Company (percentage), does not calculate correctly.
Please check the attached File
Your prompt reply will be highly appreciated by us.
Hello @Anonymous
Please update your existing measure "MS Company1" to "MS Company" and use the below code.
Hi! @Anonymous
It's ok for all Company, but if i want select only 1 or 2 companys?
All Companys:
@Anonymous , With help from date Table , you can get last 12 month data like
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi @amitchandak, thanks you for your reply!
For more details, please see the following table:
This table shows the last 12 months, consider that each month accumulates the add of the previous 12 months.
Example jpg:
File in excel format:
Thanks you
@Anonymous , I can see excel. Let me check if I can solve it.
Very thanks you !
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |