I have a dataset where I want to compute the ageing of some items to date.
Basically what I want to do is very easy, it's a subtraction of the item date and TODAY() function.
I tried to do it creating a measure using DATEDIFF, however when I use this function I cannot select the column field containing the item dates after the parenthesis.
Why I cannot use it as a measure? Should I then go to the query editor? If yes, what's the formula to use instead of DATEDIFF?
Thanks in advance.
Go to Solution.
Have you tried using the DATEDIFF function in a calculated column, rather than in a calculated measure?
Do you hve a small sample set of data?
Proud to be a Datanaut!
it worked perfectly. Could you please tell me what's the difference between a measure and a calculated column?
Sure. Here is one of the better summaries I have seen recently
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!