Forum

how to write a corr...
 
Notifications
Clear all

how to write a correct measure to compare the total sales between any two years in Power Bi

2 Posts
2 Users
0 Reactions
73 Views
(@mo92rx)
Posts: 2
Active Member
Topic starter
 

Dear Mynda 

 

 i created Table Visualization on Power Bi, showing years in rows, and total sales as column 

i would like to add also the total sales but for previous years as a column.

 

what is the right measure to add ??

 
Posted : 08/03/2020 8:04 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Mohammed,

See session 10 of the Power Pivot course for time intelligence functions. 10.02 PREVIOUSYEAR or 10.08 PARALLELPERIOD.

Kind regards,

Mynda

 
Posted : 09/03/2020 6:04 am
Share: