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.
Hello team.
I need help with a measure that I already created.
Solved! Go to Solution.
developed the solution.
Hi @Anonymous ,
There will be an error like "can't convert text type to Date type" using your original DAX formula "Average time = 12 -MONTH(FORMAT(AVERAGE(Capex[OT Date]), "MM/DD/yyyy")) ". You can create measure like DAX below, then display the result in Matrix table.
Average time = 12 -MONTH(AVERAGE(Capex[OT Date]))
Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYh8Yf4UodBCs6D1ImKZ2OIBk3Gi3vHLz3wGDmWG2hKp7g?e=ouQ1Jg
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, My dax formula does not give an error, I just need to put the first month in the subtraction like in my measure, and from there on put a 12, but for months before a 0 for for 2016, on the 2015 column it will be a 0,
Thanks for the help. I think i need to clarify: .
developed the solution.
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 |
---|---|
105 | |
102 | |
79 | |
72 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |