Forum Discussion
Month On Month Comparison between two sheets for current month value
I Have two excel which i have imported into Power bi . one table name called FINAL another table name called Template. FINAL Month&Year Plant Quan...
Hi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/ukAb0PlQWRb6N4BAQTY = SUM ( Template[Quantity] )July val finalsheet = SUMX ( VALUES ( Template[Month& Year] ), CALCULATE ( SUM ( FINAL[Quantity] ), FINAL[Month& Year] = MIN ( FINAL[Month& Year] ) ) )increase/Decrease = [QTY] - [July val finalsheet]
tamerj1
Community Champion
Community ChampionHi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/ukAb0PlQWRb6N4BA
QTY = SUM ( Template[Quantity] )July val finalsheet =
SUMX (
VALUES ( Template[Month& Year] ),
CALCULATE (
SUM ( FINAL[Quantity] ),
FINAL[Month& Year] = MIN ( FINAL[Month& Year] )
)
)increase/Decrease = [QTY] - [July val finalsheet]