Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
please help me to find out the below problem.
i have a field Which is "DATE_Field" in this if i select any two dates on my interest it will give the differences between on those selected dates
Example
| WeekAsOn |
| 24-apr-2020 |
| 17-apr-2020 |
| 10-apr -2020 |
| 31-may-2020 |
Please help me to find it
Regards,
Pradeep K.
I hope this example will help you.
=Date#(Subfield(concat(WeekAsOn,','),',',2),'DD-MMM-YYYY')-Date#(Subfield(concat(WeekAsOn,','),',',1),'DD-MMM-YYYY')
Hi Zarra,
Thanks for reply
i'm not getting the differences on two selections, because of here i'm using 3 measures. and please follow the attached png image for reference. and please tell me what is your measures.
Regards,
Pradeep K.