Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Table Format:
Month Place Amount
January Canada 1000
February Mexico 2000
March USA 3000
April Australia 4000
May India 5000
June India 6000
July Mexico 7000
August Mexico 8000
September USA 9000
how to show the June value using set analysis
how to show August value using set anlysis
How to show April Value using Set analyis
By using the below formula I am getting the max and min value but I am unable to pull the between values
(Sum({<Month = {'$(=Date(Min(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))
Can u try.
April
Sum({<Month = {'$(=Date(Min(Date#([Month],'MMMM'),4),'MMMM'))'}>}[Amount])
June
Sum({<Month = {'$(=Date(Max(Date#([Month],'MMMM'),4),'MMMM'))'}>}[Amount])
August
Sum({<Month = {'$(=Date(Max(Date#([Month],'MMMM'),2),'MMMM'))'}>}[Amount])