No expression result

[master_student]

Hello community

I would like to calculate the budget of maximum date in my excel file.

To do so, I created a variable vMaxdb =date(max(dateBudget), 'DD MMM YYYY')

and then in my expression :=sum({<[dateBudget]={$(#vmaxdb)}>}[Budget PO]/1000)

It didn't work.

Do you have an idea please.

Thanks

[oknotsen]

Notice the hash sign (the "#") in your expression. That should not be there as far as I know. Remove it and see what happens. I probably would replace it by an "=".

[Anonymous]

Hi Wiem,

if you want to force vmaxdb date to be evaluate as a number user this:

sum({<[dateBudget]={'$(#=vmaxdb)'}>}[Budget PO]/1000)

Hope this help

Maurice

[mithilesh17]

Hi,

Remove # symbol.

Regards,

[Chanty4u]

hi,

Remove  # symbol and replace with =

[sunny_talwar]

May be this:

=Sum({<[dateBudget]={"$(=Date(Max(dateBudget), 'DD MMM YYYY'))"}>}[Budget PO]/1000)

[master_student]

Hello,

I tried but it didn't work.

My goal is to display the budget By

month :

MTD , from first january until mnt po (in my excel file is not null)

and YTD

Could you send me your emails, I can't attach any file here...

Thank you for your help

[Kushal_Chawda]

try this

=sum({<[dateBudget]={"$(=vMaxdb)"}>}[Budget PO]/1000)

[HirisH_V7]

Hi,

Check with this,

sum({<[dateBudget]={'$(=Date(max([dateBudget]), 'DD MMM YYYY'))'}>}[Budget PO])/1000

Whether your Date format is  of same , dateBudget - 'DD MMM YYYY'   or not.

-Hirish

[sunny_talwar]

I am not sure who are you referring to in your post?