Forum Discussion
Solved
measure = AVERAGEX(DATEDIFF(DateA, DateB, DAY)) does not work.
Hi everybody, I have 2 colonnes says DateA and DateB with date format. If I create another C Column = DateA -DateB, it works. I have many average date difference to calculate, so I would like t...
BTRD Hi!
The main issue is that Measures operate in an aggregated context. The DATEDIFF function expects specific date values, but Measures don't know which rows to calculate on unless you use aggregations or iterate over the table using functions like AVERAGEX.
you can use this measure:
Measure =
AVERAGEX(
YourTableName,
DATEDIFF(YourTableName[DateA], YourTableName[DateB], DAY)
)if you provide me sample data and the expected result i can help you.
BBF
Hi BeaBF, thanks a lot for your explanation and help ! It works perfectly, yes !