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.
Yes, as long as datecolumn is always less than today (in the past). The format is:
Days = DATEDIFF([datecolumn],TODAY(),DAY)
This would be for a custom column.
If it is not always in the past, you could do it this way:
Days = datecolumn = TODAY() * 1.
Hi @kishoresakamuri,
Of course, you can. The syntax of DATEDIFF() is below:
DATEDIFF(<start_date>, <end_date>, <interval>)
Best Regards,
Qiuyun Yu
DATEDIFF(<start_date>, <end_date>, <interval>)
Note :
Start date should be less then end date
Hi @kishoresakamuri,
Of course, you can. The syntax of DATEDIFF() is below:
DATEDIFF(<start_date>, <end_date>, <interval>)
Best Regards,
Qiuyun Yu
I have tried multiple times to get the diference between today and start date but always getting error. All i need is just the AGING of the line item.
Also, it should be WORKING DAYS. but I could not get beyond this...
Yes, as long as datecolumn is always less than today (in the past). The format is:
Days = DATEDIFF([datecolumn],TODAY(),DAY)
This would be for a custom column.
If it is not always in the past, you could do it this way:
Days = datecolumn = TODAY() * 1.
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |