Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to creat a summarize table that contains the average and the median of a variable. The problem begins when I start to calculate the median, it shows a message "The DAX expression for calculated table 'Cumplimiento SLA' results in a variant data type for column 'Mediana Días'. Please modify the calculation such that the column has a consistent data type.". The Dax is:
Solved! Go to Solution.
Hi @Anonymous ,
You may use MEDIANX function:
MEDIANX ( SLA_BcaEmpresas, [Días] *1.0 )
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You may use MEDIANX function:
MEDIANX ( SLA_BcaEmpresas, [Días] *1.0 )
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It works! Thak u so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |