Forum Discussion

Icon for Helper II rank

Helper II

5 years ago

Help, 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 ...

Icon for Helper II rank

Helper II

5 years ago

StatePF LifePF PatronPF Gold Patron 21PF Elite Mbrs 2021QF LifeQF PatronQF Gold PatronQF Elite MbrsPF/QF Gold Patron 21PF/QF Patron 21PF/QF Life 21

AK	20	0	0	20	0	0	0	0	0	0	20
AL	14	4	0	18	19	5	0	24	0	9	33
AR	14	0	1	15	18	0	0	18	1	0	32
AZ	79	3	1	83	19	0	0	19	1	3	98
CA	108	3	0	111	13	0	0	13	0	3	121
CO	263	7	3	273	18	0	1	19	4	7	281
CT	17	0	0	17	1	0	0	1	0	0	18
DE	8	0	0	8	2	0	0	2	0	0	10
FL	75	2	0	77	28	6	1	35	1	8	103
GA	42	1	0	43	60	6	0	66	0	7	102
HI	4	0	0	4	0	0	0	0	0	0	4
IA	645	20	4	669	39	0	0	39	4	20	684
ID	46	1	0	47	3	0	0	3	0	1	49
IL	338	7	1	346	40	0	0	40	1	7	378
IN	156	0	0	156	16	1	0	17	0	1	172
KS	237	4	1	242	45	5	3	53	4	9	282
KY	17	0	0	17	14	0	0	14	0	0	31
LA	10	0	0	10	2	0	0	2	0	0	12
MA	15	0	0	15	0	0	0	0	0	0	15
MD	31	0	0	31	5	0	0	5	0	0	36
ME	7	0	0	7	1	0	0	1	0	0	8
MI	310	11	1	322	8	1	1	10	2	12	318
MN	1378	55	9	1442	42	2	1	45	10	57	1420
MO	86	2	1	89	76	3	0	79	1	5	162
MS	16	0	0	16	8	0	0	8	0	0	24
MT	166	1	1	168	4	0	0	4	1	1	170
NC	34	1	0	35	18	0	0	18	0	1	52
ND	220	1	0	221	0	0	0	0	0	1	220
NE	345	24	3	372	21	5	0	26	3	29	366
NH	8	0	0	8	0	1	0	1	0	1	8
NJ	12	0	0	12	1	0	0	1	0	0	13
NM	13	0	0	13	3	0	0	3	0	0	16
NV	29	0	0	29	3	0	0	3	0	0	32
NY	40	1	0	41	4	1	0	5	0	2	44
OH	208	8	0	216	14	3	0	17	0	11	222
OK	21	0	0	21	52	2	0	54	0	2	73
OR	47	0	0	47	5	0	0	5	0	0	52
PA	118	0	0	118	5	0	0	5	0	0	123
RI	2	0	0	2	0	0	0	0	0	0	2
SC	16	2	1	19	14	3	0	17	1	5	30
SD	499	14	14	527	10	1	1	12	15	15	509
TN	39	4	0	43	30	2	0	32	0	6	69
TX	122	9	1	132	115	13	3	131	4	22	237
UT	30	0	0	30	1	0	0	1	0	0	31
VA	39	0	1	40	11	1	0	12	1	1	50
VT	3	0	2	5	0	1	1	2	3	1	3
WA	111	2	0	113	3	0	0	3	0	2	114
WI	364	9	3	376	11	2	0	13	3	11	375
WV	7	0	0	7	3	0	0	3	0	0	10
WY	73	1	0	74	0	0	0	0	0	1	73

Related content