Show Previous month value based on month order.

Anonymous — Tue, 18 Jul 2023 13:30:29 GMT

I would like to ask about the DAX I saw online (see script below). The context is that I'm having trouble showing the previous month's because the data have gaps, these are the months with no data on the dataset (Mar 2022, May2022, & Jun 2022). I would like to ask for help to make the value show based on the month order not based on the date with data on dataset. I will attach the snips below and also the script I found. Thanks.
Target Output: ($1535) should reflect on the second column of Mar 2022 not in Apr 2022

1st col.= Report Month

2nd col.= Current Month Value

3rd col.= Previous Month Value

This is the code

previous result =
var period_context = MAX (data [period])

var previous_period =
CALCULATE(
   MAX (data [period]),
   FILTER(
      ALL (data [period]),
      data [period] <period_context &&
      SUM (data [value]) <> BLANK ()
   )
)

var previous_month_value =
CALCULATE(
   SUM (data [value]),
   FILTER(
      ALL (data [period]),
      data [period] = previous_period
   )
)

Return
if(
   ISINSCOPE (data [period]),
   previous_month_value
)

Re: Show Previous month value based on month order.

lbendlin — Thu, 20 Jul 2023 00:35:52 GMT

Add a calendar table to your data model.

topic Show Previous month value based on month order. in DAX Commands and Tips

Show Previous month value based on month order.

Re: Show Previous month value based on month order.