-
Re: max Year Month
Try this
Sum({$<Year = {$(=Max(Year))}, Month = {'$(=Max(Month))'}>} FactSoldAmount)
-
Re: max Year Month
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
Hi,
As sunny said the above expression will work fine . Can you share your app to check
-
Re: max Year Month
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
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
May Be try
Sum({$<Year =, Month = , [Year Month]={"$(=Max( [Year Month]))"}>} FactSoldAmount)
-
-
-
-
-
-
