cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to show data corresponding to the first and last date on the date slicer

Request assistance in following :

 

Following is the table that I have imported in Desktop- Table1:

Category

Date

Data

Category1

1/1/2017

10

Category1

1/2/2017

11

Category1

1/3/2017

12

Category1

1/4/2017

13

Category2

1/1/2017

14

Category2

1/2/2017

15

Category2

1/3/2017

16

Category2

1/4/2017

17

Category3

1/1/2017

18

Category3

1/2/2017

19

Category3

1/3/2017

20

Category3

1/4/2017

21

 

Report:

In the report, I want to display values based on following date slicer

Date Slicer:   

 date slicer.png

 

Only the values corresponding to the first date on the slicer and the last date on the slicer should be displayed in the report:

 

1/1/2017

1/4/2017

%change

Category1

10

13

(13-10)/10

Category2

14

17

(17-14)/14

Category3

18

21

(21-18)/18

 

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: How to show data corresponding to the first and last date on the date slicer

Hi @Aniket.

 

I created 3 measures based on your data ( I called the table Test) :

-Mini = CALCULATE(MIN(Test[Data]))

-Maxi = CALCULATE(MAX(Test[Data]))

-% Change = DIVIDE([Maxi]-[Mini],[Mini],BLANK())

Below is the image.

 

MaxMin.PNG

 

Ninter

Highlighted
Frequent Visitor

Re: How to show data corresponding to the first and last date on the date slicer

Hello @Interkoubess Ninter,

 

The dates I require are not min and max from the table, but it should be min and max from the date slicer.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

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

Community Blog

Community Blog

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

Upcoming Events

Upcoming Events

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

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors