Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all i have a variable which like this
vCurrentMonth= Max[Month No]
And month No is a column name which has 4,5,6,7,8,910
Now i want to know what does this variable means ? and what does it do
2.
What doeas the below expression does can some one explain me please
=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])
Thanks in advance
vCurrentMonth= Max[Month No]
this variable returns the maximum value for the column 'month No'
=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])
this expression returns the sum of Sales Amount where Year is the max year selected and month no is the current month
Hi,
The expression calculates [Sales Amount] for current month or current year if the max year in table is 2015 month is Jan
Regards
Anand
By your expressn:
It will return the Sum of [Sales Amount] where year is equals to maximum of year and Month is MAximum of month as in your case if Month's values are:
1, 2 , 3 4, 5 , 6 , 7 ,8 9, 10 then [Month No]={$(=vCurrentMonth)} will return Month = 10 always.
thanks
Hi Wrestler,
vCurrentMonth= Max[Month No]....(Month No)->4,5,6,7,8,910
This will takes maximum value from the Month No field.I.e; it will retrieve 10 from the field.
=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])
This shows the total sales amount of maximum year from your year field and Maximum month from your Month Field.
Regards
Krishna