Forum Discussion
Compare Last Month To Current Month
Hi deanbland ,
I don't suggest to do comparison in power bi since you have too many columns contains in one table. You need create a calculation column to show 0, 1 for each columns in the original column. If you really need to do it , you can create index column for both tables. Here is a sample for one difference column in your table:
differenceforot = IF('Current Month'[Opportunity Type] = LOOKUPVALUE('Previous Month'[Opportunity Type],'Previous Month'[Index],'Current Month'[Index]),0,1)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi, example PBI file link can be found below
https://drive.google.com/file/d/155WoUbjHNJYF456Wl1strfMdcXAv9mHl/view?usp=sharing
I am wanting the Current Month table to include a column that assigns a 1 next to any row which has changed compared to the Previous Month. As there are duplicate entries regarding the Opportunity ID, it is best to use the Form ID as the unique identifier.
Thank you
Hi deanbland ,
I don't suggest to do comparison in power bi since you have too many columns contains in one table. You need create a calculation column to show 0, 1 for each columns in the original column. If you really need to do it , you can create index column for both tables. Here is a sample for one difference column in your table:
differenceforot = IF('Current Month'[Opportunity Type] = LOOKUPVALUE('Previous Month'[Opportunity Type],'Previous Month'[Index],'Current Month'[Index]),0,1)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai