Forum Discussion
Datediff function doesn't "see" datas from fact table
Hi, EndriuBlack ,
For measures, there's not row context. So you cannot use directly the columns, you need to aggreagate your data so some aggregation fucntion such as MAX. IF you wrap it to MAX, then you can use the column.
Since measures are calculated only based on current filter context, you don't have access to rows context.
You can also use X function to retrieve that row context and access the rows (MAXX).
Super UserHi, EndriuBlack ,
For measures, there's not row context. So you cannot use directly the columns, you need to aggreagate your data so some aggregation fucntion such as MAX. IF you wrap it to MAX, then you can use the column.
Since measures are calculated only based on current filter context, you don't have access to rows context.
You can also use X function to retrieve that row context and access the rows (MAXX).
Thank You !
Now I understand it. I have used MAX function for both dates and the measure works. I see that calculating last very long so I cannot use this parameter in my report but now I know more for the future 😉
Best Regards,
