Forum Discussion
bv27718n
Helper II
Helper IIHelp, how d I get % change?
Hi I am new to power BI and have two issues: I have to different data sets, one for 2020 and one for 2021. How can I show the percent change for each row? Additionally in my data query, I have ...
bv27718nHelper II
Helper IIOkay, makes sense. I appreciate your help. I did have one last follow up, I am looking at what you did, how do you then add in the other colums likethe PF 2020? I would go into the elite 2020, create columns say for gold patron and patron and then go from there I take it.
Is there an easy way to create a "state region" table? where is that created?
richbenmintz
Resident Rockstar
Resident RockstarHi bv27718n ,
Follow the exact same pattern, create column in the table where the variance is by looking up the value from the corresponding table, then add your measures.
For the State Region Table you could use this csv and import into your model