Countrows not working properly

vivek_babu 

Updated Measure:
Measure = 
VAR r_year = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Year_windows])
VAR r_month = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Month_windows])
VAR previous_month =
SWITCH(
r_month,
"Jan", "Dec",
"Feb", "Jan",
"Mar", "Feb",
"Apr", "Mar",
"May", "Apr",
"Jun", "May",
"Jul", "Jun",
"Aug", "Jul",
"Sep", "Aug",
"Oct", "Sep",
"Nov", "Oct",
"Dec", "Nov"
)
VAR previous_year =
IF(r_month = "Jan", r_year - 1, r_year)
RETURN
CALCULATE(
COUNTROWS(BLADE_LOGIC_FIM),
FILTER(
BLADE_LOGIC_FIM,
BLADE_LOGIC_FIM[Reporting Year_fim] = previous_year &&
BLADE_LOGIC_FIM[Reporting Month_fim] = previous_month
)
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Hi vivek_babu ,
Create a calculated column for Month number using DAX bellow, if you already have one, just skip this step:

Reporting Month Number = 
SWITCH(
    PA_TOOL_COMPLIANCE_WINDOWS[Reporting Month_windows],
    "Jan", 1,
    "Feb", 2,
    "Mar", 3,
    "Apr", 4,
    "May", 5,
    "Jun", 6,
    "Jul", 7,
    "Aug", 8,
    "Sep", 9,
    "Oct", 10,
    "Nov", 11,
    "Dec", 12
)

Now youu can create a measure to calculate previous month total by this DAX:

Measure = 
VAR r_year = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Year_windows])
VAR r_month = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Month Number_windows]) -- Coluna com números para meses (1 = Jan, 12 = Dec)
VAR prev_month = IF(r_month = 1, 12, r_month - 1)
VAR prev_year = IF(r_month = 1, r_year - 1, r_year)
RETURN
CALCULATE(
    COUNTROWS(BLADE_LOGIC_FIM),
    FILTER(
        BLADE_LOGIC_FIM,
        BLADE_LOGIC_FIM[Reporting Year_fim] = prev_year &&
        BLADE_LOGIC_FIM[Reporting Month Number_fim] = prev_month
    )
)

Hi vivek_babu  Try this:

Measure = 
var r_year = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Year_windows])
var r_month = SELECTEDVALUE(PA_TOOL_COMPLIANCE_WINDOWS[Reporting Month_windows])
var prev_date = EOMONTH(DATE(r_year, MONTH(DATEVALUE("1 " & r_month & " " & r_year)), 1), -1)
var prev_year = YEAR(prev_date)
var prev_month = FORMAT(prev_date, "MMM")
return
CALCULATE(
    COUNTROWS(BLADE_LOGIC_FIM),
    FILTER(
        BLADE_LOGIC_FIM,
        BLADE_LOGIC_FIM[Reporting Year_fim] = prev_year &&
        BLADE_LOGIC_FIM[Reporting Month_fim] = prev_month
    )
)

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

Hi Bibiano_Geraldo shafiz_p Kedar_Pande 

Thanks for providing your solutions. Unfortunately, all the solution is giving me blank values. In all of three solutions the previous year and previous month value is coming correctly but when we countrows of the table by filtering the table's year and month with our previous year and previous month values is not working. Not sure why it is not filtering the data properly 

@Jai-Rathinavel @lbendlin @DataNinja777 @FreemanZ @Greg_Deckler @shafiz_p @Ritaf1983 @Kedar_Pande @v-jialongy-msft @v-xianjtan-msft @vojtechsima

Regards

Vivek N

Hi,

Please find the below sample data, Expectation is that the when user selects the year and month in the slicer then it needs to show the previous month sales. This is just an example i created to mimic my original requirement.

Current Logic: