By default App data to be shown based on max process month

[hassansm]

Hi,

My requirement is to show the app data (KPI, chart, table) by default based on the max process month, but data should be refreshed based on user selection as well.

Process date	Actual cost
30-Dec-2017	1000
01-Feb-2018	2000
31-Jan-2018	5000
19-Mar-2018	6000

Thanks

[jyothish8807]

Try this:

Sum({<[Process date]={"$(=max([Process date])"}>}[Actual cost])

Br,

KC

[jyothish8807]

In this case, if you dont select any month while opening the application, it will take 19 mar 18 as max date and then if you select any other date then that will become max date.

[shiveshsingh]

Put this in your expression,

=Sum({<[Process date] ={"$(=max(date(date#([Process date],'DD-MMM-YYYY'),'DD-MMM-YYYY')))"}>}[Actual cost])

Dimension ---> [Process date]

[hassansm]

Hi Jyothish,

I have applied your suggestion in KPI object , nothing is shown. Instead of Process date , i am using monthyear field and the format of this filed is "Mar-2018".

Please suggest .

Rgds,

Hassan

[hassansm]

Hi,

I have applied your suggestion in KPI object , nothing is shown. Instead of Process date , i am using monthyear field and the format of this filed is "Mar-2018".

Please suggest .

Thanks and Regards,

Hassan

[shiveshsingh · Accepted solution]

Hi

Can you try this?

=Sum({<[monthyear] ={"$(=max(date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')))"}>}[Actual cost])

[jyothish8807]

try this:

=Sum({<$(=date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')) ={"$(=max(date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')))"}>}[Actual cost])

Br,
KC

[hassansm]

Yes, It's working. Thanks for your suggestion.

How to apply this solution in filter pane object, i have monthyear filter field, by default max monthyear to be selected while opening the app.

[chinnuchinni]

you can use the onopen trigger