Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)
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?

1 Answer

0 votes
by (22.5k points)

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] 

Want to learn more about Power Bi, Refer & learn Power bi   

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

Browse Categories

...