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'm looking for the right measure to calcuate the years of service from "Date Hired", as at today. I'm unable to use DATEDIFF due to Direct Query mode.
Solved! Go to Solution.
I tried like this in direct query and it worked :
Diff from Today = SUMX('order',DATEdiff('order'[Sales_Date],TODAY(),MONTH) )
or
Diff from Today = AVERGAEX('order',DATEdiff('order'[Sales_Date],TODAY(),MONTH) )
But for display, context is very important
I tried like this in direct query and it worked :
Diff from Today = SUMX('order',DATEdiff('order'[Sales_Date],TODAY(),MONTH) )
or
Diff from Today = AVERGAEX('order',DATEdiff('order'[Sales_Date],TODAY(),MONTH) )
But for display, context is very important
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 |
---|---|
109 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |