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.
Hi everyone,
I want to create a measuere to find the difference in months between two dates. One date is from the dataset and the other is TODAY() function. Could anyone please suggest on how can I create this measure?
Thank you
Best Regards,
DG
Solved! Go to Solution.
If you are trying to point on your column, and if it's a one row value then try this code
Measure = DATEDIFF(MAX(Your_date),TODAY(),MONTH)
Did it work ? Mark it as a solution to help spreading knowledge.
A kudos would be appreciated
Measure = DATEDIFF(Your_date,TODAY(),MONTH)
Did it work ? Mark it as a solution to help spreading knowledge.
A kudos would be appreciated
It is not working for me.
Could you please suggest some other way ?
Could you provide a data sample or a screenshot so I can understand more your need
I want to find difference of months between LAST_ORDER_DATE and TODAY() and LAST_ORDER_DATE is already in the database. but when I do MEASURE = DATEDIFF( in this place after opening bracket I'm unable to refer to column named LAST_ORDER_DATE.
Hi ,
you can use Values function. e.g Values(LAST_ORDER_DATE) to refer the column.
Thanks,
Shanthakumar
If you are trying to point on your column, and if it's a one row value then try this code
Measure = DATEDIFF(MAX(Your_date),TODAY(),MONTH)
Did it work ? Mark it as a solution to help spreading knowledge.
A kudos would be appreciated
Thank you so much for your help It worked.
Regards
You are welcome 👍
Did it work ? Mark it as a solution to help spreading knowledge.
A kudos would be appreciated
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |