-
Re: max Year Month
Sunny Talwar Apr 16, 2018 3:30 PM (in response to Mariam Ovasheli)Try this
Sum({$<Year = {$(=Max(Year))}, Month = {'$(=Max(Month))'}>} FactSoldAmount)
-
Re: max Year Month
Mariam Ovasheli Apr 17, 2018 2:58 AM (in response to Sunny Talwar )hi, It doesn't work without selection. If I select 2018 or another year it is correct but Without it it Doesn't Show anything
-
Re: max Year Month
Keerthika B Apr 17, 2018 3:04 AM (in response to Mariam Ovasheli)Hi,
As sunny said the above expression will work fine . Can you share your app to check
-
Re: max Year Month
Sasidhar Parupudi Apr 17, 2018 3:50 AM (in response to Mariam Ovasheli)I think you need to use date field to filter you data rather than using year and month fields
Please share your calendar so that we can help you better
-
Re: max Year Month
Mariam Ovasheli Apr 17, 2018 3:53 AM (in response to Sasidhar Parupudi)Hi, This is my calendar.
Calendar:
Load
Distinct
%lnk_date,
Date(%lnk_date) as Date,
Day(date) as day,
year(%lnk_date) as Year,
month(%lnk_date) as Month,
'Q' & ceil(month(%lnk_date)/3) as Quarter,
'Q' & ceil(month(%lnk_date)/3) & '`' & right(year(%lnk_date),2) as [Year Quarter],
ceil(month(%lnk_date)/3) as %QuarterNum,
month(%lnk_date) & '`' & right(year(%lnk_date),2) as [Year Month] ,
year(%lnk_date)*100 + month(%lnk_date) as %ym
Resident GasOperatingSales;
-
Re: max Year Month
Sasidhar Parupudi Apr 17, 2018 7:04 AM (in response to Mariam Ovasheli)May Be try
Sum({$<Year =, Month = , [Year Month]={"$(=Max( [Year Month]))"}>} FactSoldAmount)
-
-
-
Re: max Year Month
Sunny Talwar Apr 17, 2018 4:48 AM (in response to Mariam Ovasheli)Would you be able to share a sample or some sample data to look at this?
-
-
-
Re: max Year Month
David Forest Apr 16, 2018 3:45 PM (in response to Mariam Ovasheli)Please delete this duplicate thread....