cancel
Showing results for
Did you mean:
Highlighted
Helper V

## CALCULATE with LASTDATE

Hello,

i try to find a way to integrate LASTDATE in a calculation. A possibility is:

VAR LD = LASTDATE(Table1[Date])

RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)

The problem is that i dont have the last date considering Table1[Part] <> "B". Some ideas what to adjust?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: CALCULATE with LASTDATE

VAR LD = CALCULATE(LASTDATE(Table1[Date]),Table1[Part] <> "B")

RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

2 REPLIES 2
Highlighted
Super User IV

## Re: CALCULATE with LASTDATE

VAR LD = CALCULATE(LASTDATE(Table1[Date]),Table1[Part] <> "B")

RETURN Number = CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = LD)

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Highlighted
Super User IV

## Re: CALCULATE with LASTDATE

@Pikachu-Power , try like

CALCULATE(COUNT(Table1[PNR]); Table1[Part] <> "B"; Table1[Date] = lastdate(Table1[Date] ))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors