CALCULATING % CHANGE OVER TIME MEASURE WHILE IGNORING THE DATE SLICER

[Ishwarya]

I am trying to calculate percentage change over time by taking inputs from the date slicer but after adding the measure to a table visual I don't want the date slicer to filter the measure.

I have this below table format in my report.

Below is my report: Amount is aggregated for each class by the filters and selected dates

Now, I need to calculate % change for Amount by the current user date selected and exact time period last year (I.e July 1st-Jul 28th 2021 vs July 1st-Jul 28th 2020) 

I want to add this measure next to the Amount. 

In order to calculate the %, first I created Amount for last year (July 1st-Jul 28th 2020) which is displaying blank as it doesn't fall under the user selected date (July 1st-Jul 28th 2021).

Please help me how to calculate the % without displaying blank in the table.

[vanessafvg]

Not sure if i fully understand your requirement but see attached.

What i did was add a date table, then i create a previous year measure using  the sameperiodlastyear function.

see attached.

[vanessafvg]

pleases provide the data in text and not an image.

[Ishwarya]

Here it is,

Date              Amount    Type           Code       Class         NonProfit

7/28/2021     445           School        1             Children     Y

7/22/2021     186           University    2            Adult         

7/17/2021     542           School         22          Adult    

7/13/2021     454           School         25          Adult 

7/9/2021       372           School         28          Children      Y

7/4/2021       42            School          5           Children      

7/1/2021       1654        School          1           Children      

7/20/2021     138          School          2           Adult

7/28/2021     40            School          22         Adult

7/28/2020     248          School         22          Adult     

7/22/2020     336          University    1            Adult         

7/17/2020     200          University     22         Children    Y

7/13/2020     580          School         2           Children

7/9/2020       156          School         2           Adult       

7/4/2020       403          School         2           Adult      

7/1/2020       207          School         22          Adult      Y

7/20/2020     181          School         1           Adult

7/28/2020     357          School          1           Adult

[vanessafvg]

hi thanks but no matter what i cannot format this data without working really hard, it doesnt paste the columns properly,  where did you copy from, can you copy from excel so that its formatted in a way thats easy to use.  Not sure why when it copies and pastes it loses its formatting. 

[Ishwarya]

Date	Amount	Type	Code	Class	NonProfit
7/28/2021	445	School	1	Children	Y
7/22/2021	186	University	2	Adult
7/17/2021	542	School	22	Adult
7/13/2021	454	School	25	Adult
7/9/2021	372	School	28	Children	Y
7/4/2021	42	School	5	Children
7/1/2021	1654	School	1	Children
7/20/2021	138	School	2	Adult
7/28/2021	40	School	22	Adult
7/28/2020	248	School	22	Adult
7/22/2020	336	University	1	Adult
7/17/2020	200	University	22	Children	Y
7/13/2020	580	School	2	Children
7/9/2020	156	School	2	Adult
7/4/2020	403	School	2	Adult
7/1/2020	207	School	22	Adult	Y
7/20/2020	181	School	1	Adult
7/28/2020	357	School	1	Adult