Forum Discussion
Pass Date Slicer Value on a Calculated Column
I am trying to get a past date pending case count from a live database, based on the Date selected in the slicer. But what I have is not a daily snapshot to know what was the past status, but a live ...
Hi GilbertQ, First of all many thanks for your kind respon
I believe may be I should be more clear. I want to pass date slicer value on a calculated column. This way, I will be able to calculate the Ageing from the Case Created Date till the Selected Date in Slicer on the fly. As and when the Date slicer changes, I need the dynamic calculation to happen in the calculated column and give the result accordingly. This way, I want to make use of the Live data without the need of a daily data snapshot.