cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Value from 2 tables based on Date

Hello Everyone,

Ok, i have a very naive doubt. Following is the elaboration:

I have value [Quantity] from table 1 and value  [Quantity] from table 2 and i want to show these values in the matrix with the following condition.

If date<= today, table2[value] ,

else table1[value]

and i am clueless about the exact formula that can help me achieve this.

Cheers!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Value from 2 tables based on Date

Hi @Gopal30

```Measure =
IF(
MAX( 'Calendar'[Date] ) <= TODAY(),
SUM( table2[Quantity] ),
SUM( table1[Quantity] )
)```

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Super User IV

## Re: Value from 2 tables based on Date

Hi @Gopal30

```Measure =
IF(
MAX( 'Calendar'[Date] ) <= TODAY(),
SUM( table2[Quantity] ),
SUM( table1[Quantity] )
)```

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

## Re: Value from 2 tables based on Date

@Mariusz  Thanks a lot!

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors