cancel
Showing results for 
Search instead for 
Did you mean: 

Creating NEW table called B using modeling menu and new table option with DAX functions

Hi, I'll really apreciate your help.

 

If I have a table called A on Power BI.

How I can create a NEW table called B using modeling menu and new table option with DAX functions

 

Condition: Records In table B must be the newest taking column “Date” as filter

 

Look at next examples:

 

TABLE: A

   
    

ID

DATE

STATUS

NAME

1

1/2/2017

A

Mike

2

2/2/2017

A

Matt

3

3/3/2017

A

Paul

4

4/4/2020

C

Marck

5

5/5/2018

D

Zoe

1

1/2/2018

B

Mike

3

3/3/2018

C

Paul

5

5/5/2016

D

Zoe

1

1/2/2019

C

Mike

3

3/3/2019

D

Paul

5

5/5/2015

D

Zoe

1

1/2/2020

B

Mike

 

 

TABLE B

   
    

ID

DATE

STATUS

NAME

1

1/2/2020

B

Mike

2

2/2/2017

A

Matt

3

3/3/2019

D

Paul

4

4/4/2020

C

Marck

5

5/5/2018

D

Zoe

 

Status: New
Comments
Community Support
Frequent Visitor

Thanks a Lot...!!