cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

## Current Year Previous Month DAX

Hello All,

I am not getting correct t calculated value for previous Month column , For example in below screen shot CM sales for March =3,881,693. in PM Sales column of April month i am expecting 3,881,693.

```CM Sales = CALCULATE(SUM('sales'[salesamt]), bcalendar[byear]= YEAR(TODAY()))-- Current Year Sales by month

PM Sales = CALCULATE (SUM('sales'[salesamt]),PREVIOUSMONTH(bcalendar[bdate]), bcalendar[biyear]= YEAR(TODAY())) ---Current Year Previous Month Sales```

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Current Year Previous Month DAX

Hi @prasy14,

Please try this:

```PM Sales =
CALCULATE (
SUM ( 'Sales'[SalesAmount] ),
FILTER (
ALLSELECTED ( 'bcalendar' ),
'bcalendar'[bdate].[MonthNo]
= MONTH ( MAX ( 'bcalendar'[bdate] ) ) - 1
&& 'bcalendar'[byear] = YEAR ( TODAY () )
)
)```

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 REPLIES 7
Established Member

## Re: Current Year Previous Month DAX

Hi @prasy14

This could be useful for you

https://1drv.ms/f/s!AuU-Ye8UGM4Rko0xvebM1ZQ7ZZhDeg

Senior Member

## Re: Current Year Previous Month DAX

You can try:

`PM Sales = CALCULATE ( [CM Sales],PREVIOUSMONTH(bcalendar[bdate]) ) ---Current Year Previous Month Sales`

Though if it were me, i'd have a 'Year' slicer, to make it easier.

Regular Visitor

## Re: Current Year Previous Month DAX

Hello @mattbrice,

i have to display Current Year,Last Year, LLY,LLLY by months as well that is reason i am not using year slicer.

the code which you have provided is giving me blank values.

Regular Visitor

## Re: Current Year Previous Month DAX

Thanks for PBIX file, I still get blank values when i use the DAX and I do have same relationship between the tables as yours

Established Member

## Re: Current Year Previous Month DAX

@prasy14
Is possible you can send me your pbix file to find a better solution?
likesilverfrog@hotmail.com
Senior Member

## Re: Current Year Previous Month DAX

Does your 'bcalendar' table include dates for the prior month? prior year?

Super Contributor

## Re: Current Year Previous Month DAX

Hi @prasy14,

Please try this:

```PM Sales =
CALCULATE (
SUM ( 'Sales'[SalesAmount] ),
FILTER (
ALLSELECTED ( 'bcalendar' ),
'bcalendar'[bdate].[MonthNo]
= MONTH ( MAX ( 'bcalendar'[bdate] ) ) - 1
&& 'bcalendar'[byear] = YEAR ( TODAY () )
)
)```

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 55 members 1,445 guests
Recent signins:
Please welcome our newest community members: