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

[master_student]

Sunny,

Could you please give me your email. I will send you my application.

Thanks

[oknotsen]

Just attach the application to your post instead.

[master_student]

Hello,

Thanks for your responses.

The problem is solved.

An other question, I have a date fiels in th that format

How to convert it in date without hours, only 29/03/2016

[oknotsen]

Please start a new topic for a new question.

Since your current problem is solved, please flag the correct answer by clicking on the "Correct Answer" button near that reaction. Also consider flagging Helpful answers by clicking on the Action option near that reply and selecting "mark as helpful".

Thank you.

[Kushal_Chawda]

Master_Student‌

Kindly post the solution here and mark it as correct answer so that other can refer to same if they have same issue.

Also for new query please open a new thread.

[Anonymous]

you have assigned wrong variable name .

tryy this

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