Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Dates of each month in the column
When i am loading the date it is coming as a general value.
I tried changing the excel format to date. Still it is coming as a general value.
Please see the date image of the excel and QLik sense
May be this
Sum({1<Billing_Date={">=$(=Date(YearStart(Max(Billing_Date),-2)))<$(=Date(MonthStart(AddYears(Max(Billing_Date), -2), 1)))"}, Year1={"2016"}>} value)