Forum Discussion
sousahebert
8 years agoFrequent Visitor
Get data from same weekday from last month
Hi, I'd like to know how to get values from same period in last month. For exampe: Data Value 02/01/2018 (2th Month Weekday) - 100 04/12/2018 (2th Month Weekday) - 110 0...
ccakjcrx
Resolver I
8 years agoHey sousahebert!
Sorry I'm just now getting back to this. It looks like you might be after the value from thirty days ago. Here is the formula I used:
MsrValueLastMonth =
SUMX(
DATEADD(MES_ATUAL[Data de Cadastramento 2],-30,DAY),
[Qtd_Processo_M0]
)Assuming that is what you need, this expression should help. It simply goes back thirty days and executes the [Qtd_Processo_M0] measure. You can change the second parameter of the DATEADD expression to go back a certain number of days. You don't have date values for every day of the month in the MES_ATUAL table, so some rows will be blank. Here is what it looks like in the table visual:
HERE is a link to your sample file with the added expression.
Hope this helps.
sousahebert
8 years agoFrequent Visitor
Hi
I Will Try this..
Tks!
- v-jianhe-msft8 years ago
Resolver II
Hi,
May I know how is the issue going currently?
BR,
Henry