How to exclude rows from table in power bi based on min date

[sakthi0311]

Hi All,

I need to exclude rows based on min date from the table. Also, it should be dynamic.

Please find the below sample data 

         Date            A             B         C             D

16-AUG-2018  XAG/USD    0          0        14.4461
16-AUG-2018  XAU/USD    0          0        1175.26
17-AUG-2018  XAG/USD    0          0        14.6289
17-AUG-2018  XAU/USD    0          0        1173.52
20-AUG-2018  XAG/USD    0          0        114.675
21-AUG-2018  XAU/USD    0          0        1190.26

22-AUG-2018  XAG/USD    0          0        14.7713

My output is

17-AUG-2018  XAG/USD    0          0        14.6289
17-AUG-2018  XAU/USD    0          0        1173.52
20-AUG-2018  XAG/USD    0          0        114.675
21-AUG-2018  XAU/USD    0          0        1190.26
22-AUG-2018  XAG/USD    0          0        14.7713

Kindly help to resolve this. Thanks in advance 

[rajulshah · Accepted solution]

Hello @sakthi0311,

I guess while calculating measure that is used for D, you can filter the dates table by the following expression maybe:

FILTER(datestable,datestable[date]<>MIN(datestable[date])

What I suggest is if you can share the sample data, it would be better to solve your issue.

Regards.

[v-chuncz-msft · Accepted solution]

@sakthi0311,

You may add a calculated column and make use of Slicers and filters.

Column =
VAR d = MIN ( Table1[Date] ) RETURN IF ( Table1[Date] = d, 1, 0 )

[rajulshah · Accepted solution]

Hello @sakthi0311,

I guess while calculating measure that is used for D, you can filter the dates table by the following expression maybe:

FILTER(datestable,datestable[date]<>MIN(datestable[date])

What I suggest is if you can share the sample data, it would be better to solve your issue.

Regards.

[sakthi0311]

Hi rajulshah,

Column D is not a calculated measure . It is a default column from db. 

[sakthi0311]

Hi,

I want to exclude rows which has min date from the table. 

Please find the sample data below. The date can get add. In that I need to remove min date dynamically.

       Date                A             B              C               D
16-AUG-2018  XAG/USD      0              0           14.4461
16-AUG-2018  XAU/USD      0              0           1175.26
17-AUG-2018  XAG/USD      0              0           14.6289
21-AUG-2018  XAU/USD      0              0           1190.26
22-AUG-2018  XAG/USD      0              0           14.7713
22-AUG-2018  XAU/USD      0              0           1195.86

My output should be

       Date                A             B              C               D

17-AUG-2018  XAG/USD      0              0           14.6289
21-AUG-2018  XAU/USD      0              0           1190.26
22-AUG-2018  XAG/USD      0              0           14.7713
22-AUG-2018  XAU/USD      0              0           1195.86

If anyone has idea please help. Thanks in advance.

[rajulshah]

Can you please share your sample pbix file with sample data?

[sakthi0311]

Hi,

Pls find the below link for sample data.

http://18.219.11.122/sampledata.xlsx