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.