Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |