Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to calculate first purchase month. Please refer the attachment. we need reruirement1,2,3
use firstsortedValue()
for detail see in help menu.
Regards,
Prashant Sangle
PFA..
I've created the field Month_For just to change the format from your data set
MonthName(Date#(Month,'MMMYYYY')) as Month_For
Expression is used
MonthName(Min(TOTAL <[Corp Parent]> {<Value={"=Sum(Value)>0"}>} Month_For))