Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |