Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
My_Rebecca
Creator
Creator

Date relevant expression

I need to calculatethe quantity with day GR_Date is greater or equal to variable Last Month End Day.

"Last Month End Day" has been reached as variable.

How to correct following expression?

count({<GR_Date>={"$(Last Month End Day)"}>}distinct(GR_Number&[GR_Line No.]))

Labels (1)
5 Replies
Chanty4u
MVP
MVP

Try this 

count({<GR_Date={">=$(=MonthEnd(AddMonths(Max(GR_Date), -1)))"}>} distinct GR_Number & GR_Line No.)

 

My_Rebecca
Creator
Creator
Author

"Last Month End Day" has been reached as variable. Your expression does not work.

My_Rebecca_0-1684829280316.png

 

Chanty4u
MVP
MVP

Can you attach full screen

Just wanted to see the results below in expression editor area 

My_Rebecca
Creator
Creator
Author

My_Rebecca_0-1684831900071.png

 

My_Rebecca
Creator
Creator
Author

Dear @Chanty4u , could you please take a look at this issue? I would not get the correct answer.