16 Replies Latest reply: Jan 5, 2017 1:37 PM by Sunny Talwar

# Help

Dear Team,

i stuck a requirement. i have data oct, nov dec month of different dates.

in oct month i have 24/10/2016,25/10/2016,26/10/2016,27/10/2016,28/10/2016

In Nov Month i have 26/11/2016,27/11/2016,28/11/2016,29/11/2016,30/11/2016

In Dec Month i have 11/12/2016,12/12/2016,13/12/2016,14/12/2016,15/12/2016,16/12/2016

For this i am sharing a qvd where all data exit with date.

i want to show only each month of maximum date wise Avl Value.If i see in oct month then it show only 28/10/2016 date regarding value

If i see in Nov month then it show 30/11/2016 date regarding value

If i see in Decmonth then it show 16/12/2016  date regarding value

How is it.Kindly Help Me For soliving this issue. Maximum date of each month

• ###### Re: Help

Try

sum( {<Date={\$(=max(Date))}> Value }

• ###### Re: Help

TRY

sum( AGGR(if(DATE = Max(TOTAL <MONTHIS> DATE) ,Amountt),MONTHIS,DATE))

• ###### Re: Help

panipat1990

• ###### Re: Help

i will close. But This code is not running.

I tell you. i make a straight table.

My dimension is article and My First measure is Current month's max date wise Value like Sum({<Link_Date={Max(Link_Date)}>}Value

But when i Make Second measure for last month then what i write for maximum date for last month.

Same As Previous  to month

• ###### Re: Help

Like this?

• ###### Re: Help

Dear Sunny,

i am attaching a calendar qvd.then write code. when i am using this is not working

• ###### Re: Help

Try this:

Sum({\$<DATE={"\$(=Date(Max({<DATE = {'<\$(=MonthStart(Max(DATE)))'}, Month, [Avl Value] = {'*'}>} DATE)))"}, Month>} [Avl Value])

• ###### Re: Help

But i am using the fiscal month and i am left keep using in data model when i associate the calendar. and

i am using date format DD/MM/YYYY..Kindly use this and then write code

• ###### Re: Help

Gourav sir kindly provide your application and be less dependent on people here. I am helping out here because I want, not because I get paid

I hope you will understand

Best,

Sunny

• ###### Re: Help

Dear Sunny

Here i am attaching my app

• ###### Re: Help

Try this:

• ###### Re: Help

Kindly can you send me the app where you written this code.

• ###### Re: Help

Here you go (sorry I thought I attached it earlier)

• ###### Re: Help

If i created for Oct sep Aug Jul Jun May Apr

Then only in your code -1,-2,-3,-4,-5  Only i will have to do this

• ###### Re: Help

Yes