Power BI - Daily difference as a value and percentage

Question

I am having Power Bi report which shows the Date,City,Town,Order Number and want to create a report which shows us the difference as value and percentage,How can I do that?

Answer 1

Use the following measure

Volume t-1 =
var ThisDate = Table1[Date]
var PrevDate =
    MAXX(FILTER(ALL(Table1[Date]), Table1[Date] < ThisDate), Table1[Date])
var PrevValue =
    MAXX(FILTER(Table1, Table1[Date] = PrevDate), Table1[Current Volume])
return
    PrevValue

Difference = [Current Volume] - [Volume t-1] 

Intellipaat provides Power BI Online Course, Enroll now to enhance your career!

Enroll in this Cognos Analytics Training in Singapore provided by Intellipaat to learn from experts.

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI