Finding Percent change of a column?

[milkmoneymike]

Hello all

I am looking to find percentage change over each row from the previous day. I have two columns a date column and then a total column for each of the dates. I am having issues finding a formula to show percent change. Any information would be helpful! 

[AlB]

@milkmoneymike 

The code above works fine. See it all at work in the attached file.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[milkmoneymike]

Awesome it worked and thank you! 

[AlB]

@milkmoneymike 

Can you provide the example data above in text-tabular format, so that it can be copied, rather than on a pic?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[milkmoneymike]

Sample data csv 

Here is the csv file of the table. you can disregard the time stamps on the dates wasnt sure how to remove those before sharing

[AlB · Accepted solution]

Hi @milkmoneymike 

Try this for a new calculated column. Format as %

Perc_Change =
VAR previousDate_ =
    CALCULATE (
        MAX ( Table1[Date] ),
        Table1[Date] < EARLIER ( Table1[Date] ),
        ALL ( Table1 )
    )
VAR currentVal_ = Table1[Count]
VAR previousVal_ =
    CALCULATE (
        DISTINCT ( Table1[Count] ),
        Table1[Date] = previousDate_,
        ALL ( Table1 )
    )
RETURN
    DIVIDE ( currentVal_ - previousVal_, previousVal_ )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[milkmoneymike]

Thank you for the quick reply. I tried the calculated column you suggested but it creates the column but only returns blanks. Any suggestions?