Community Summit Europe | March 9-12, 2020 | Barcelona, Spain Register today
View My Drafts
Hi Team, I have two tables like one is for the month of may and another one is for the month of June,
in these two tables I have one common column "category" ,Now I want to show categorywise difference in one table
Hello Aravind Reddy,
I am providing a 'single point' PowerBI solution (.pbix) that utilizing your May and June data displays
I provide details on the solution below but first wanted to suggest some other ideas.
By referring to this as a 'single point' solution, I mean to say it is specific to your May and June data and does not account for any previous or future month comparisons. For example, Comparing June to July, July to August and so on.
In fact, I suggest you may want to consider preparing your monthly data creating all needed data points prior to importing into PowerBI. You could then focus on utilizing PowerBI for visualization and using DAX for any measures to help with analyzing your data. In short, even though this can be done in PowerBI (using the workflow approach of M), a better practice would be to prepare your data outside of PowerBI.
If your data resides in relational tables you could develop SQL to perform a monthly comparison between tables and report as needed. If your data resides in Excel you can achieve similar results using vlookup (or Hlookup depending on your row/column orientation).
INorNOT.pbix performs the following steps:
This is akin to an SQL 'Left Join' (also known as 'Left Outer Join').
This is akin to SQL 'inner join'.
I hope this helps.