Select 2 Random dates on Filters on main page and see the difference in status/value of projects .

[AdithyaVar]

Data is available in this manner

Project	Name	Staus	Start Date	Amount	Reporting Date
1	abc	Open	7/1/2021	1000	11/1/2021
2	def	Close	7/5/2021	2000	11/1/2021
3	ghi	Cancelled	6/2/2021	3000	11/1/2021
4	jkl	Inactive	8/4/2021	4000	11/1/2021
5	mno	Inactive	6/1/2021	5000	11/1/2021
6	pqr	Open	7/18/2021	6000	11/1/2021
7	stu	Hold	7/7/2021	7000	11/1/2021
1	abc	Hold	7/19/2021	1000	11/2/2021
2	def	Close	7/5/2021	2500	11/2/2021
3	ghi	Cancelled	6/20/2021	3000	11/2/2021
4	jkl	Active	8/4/2021	3300	11/2/2021
5	mno	Inactive	6/1/2021	5000	11/2/2021
6	pqr		7/7/2021	6200	11/2/2021
7	stu	Hold	7/7/2021	7000	11/2/2021
1	abc	Open	7/1/2021	1200	11/3/2021
2	def	Close	7/5/2021	2500	11/3/2021
3	ghi	Cancelled	6/2/2021	0	11/3/2021
4	jkl	Active	8/4/2021	3300	11/3/2021
5	mno	Active	6/1/2021	5250	11/3/2021
6	pqr	Open	7/18/2021		11/3/2021
7	stu	Hold	7/7/2021	7000	11/3/2021
8	vwx	Open	8/12/2021	9000	11/3/2021
1	abc	Open	7/1/2021	1200	11/4/2021
2	def	Close	7/5/2021	2500	11/4/2021
3	ghi	Cancelled	6/2/2021	4000	11/4/2021
4	jkl	Inactive	8/4/2021	3300	11/4/2021
5	mno	Inactive	6/1/2021	5250	11/4/2021
6	pqr	Open	7/18/2021	6200	11/4/2021
7	stu	Hold	7/7/2021	7400	11/4/2021
1	abc	Open	7/1/2021	1200	11/5/2021
2	def	Close	7/5/2021	2500	11/5/2021
3	ghi	Cancelled	6/2/2021	4000	11/5/2021
4	jkl	Inactive		3300	11/5/2021
5	mno	Inactive	6/1/2021	5250	11/5/2021
6	pqr	Open		6200	11/5/2021
7	stu	Hold	7/10/2021	7400	11/5/2021
8	vwx	Open	8/12/2021	9000	11/5/2021

Requirement is as shown below

Requirement: 2 Dates will be selected as filters on the main page. Based on the filters selected a table should be created so as to see the difference between status/values change between 2 dates.

[v-janeyg-msft · Accepted solution]

Hi, @AdithyaVar 

According to your description, you can create two date column tables for slicer and create measures to show your desired results.

Like this:

Startdate1 =
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [Project] = SELECTEDVALUE ( 'Table'[Project] )
                && [Name] = SELECTEDVALUE ( 'Table'[Name] )
                && [Reporting Date] = SELECTEDVALUE ( Tablemin[Date] )
        ),
        [Start Date]
    )
VAR b =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [Project] = SELECTEDVALUE ( 'Table'[Project] )
                && [Name] = SELECTEDVALUE ( 'Table'[Name] )
                && [Reporting Date] = SELECTEDVALUE ( Tablemax[Date] )
        ),
        [Start Date]
    )
RETURN
    IF ( a <> b, a )

Best Regards,

Community Support Team _Janey

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

[amitchandak]

@AdithyaVar , check if this can help

//Difference between two selected dates, Assume range as been selected. A date table
diff =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = maxx(allselected('Date'),'Date'[Date])
return
if( calculate( Max(Table[Status]), filter('Date', 'Date'[Date]=_min )) <>
calculate( Max(Table[Status]), filter('Date', 'Date'[Date] =_max )) , "Changed", "New")