Counting back to front

[#1]

Hey guys, how are you?

Well, I have a doubt, I want to make a code that returns me something like that:

Last network day of month = 1;

Penultimate network day of month = 2 and goes on...

Sincerely, Luiz

[Digvijay_Singh]

Can you elaborate more, dimension, expression, business need etc

[#3]

I want to show how much is sold in the end of the month, how much it represents comparing with total. but I want to choose the range for example: in the last 3 days or 4 days.

[Digvijay_Singh]

You may try with monthend function, as such -

Datefield<=MonthEnd(Datefield) and Datefield > Date(MonthEnd(Datefield)-3)

[maxgro]

if you have a calendar in your data model you can add a field with the number of days

last day of month = 1

......................... = 2

and so on

In your chart you can use set analysis to filter the n last days of month