cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Comparing entire row in table

Hi,

So far i succeeded to compare yesterday with today. But i am doing this by creating two measures, one to get the value from yesterday and one to calculate the difference between yesterday and today. In my table I have 14 columns. Is there a way to compare the whole row at once?

Relationships

Everything comes from a single table (and measures form that table). Date has a many to one relationship with the table.

date - 1: many - table1

Measures1 - get the value from yesterday

com_test = VAR PriorDay = SELECTEDVALUE(table1[date])-1

RETURN
CALCULATE(
( 'table1'[gb_total_supply]),
ALL ( table1[date]),
table1[date] = PriorDay
)

Measures2 - calculate the difference in %
com_test % difference from gb_total_supply =
VAR __BASELINE_VALUE = [measure1]
VAR __VALUE_TO_COMPARE = [measure2]
RETURN
IF(
NOT ISBLANK(__VALUE_TO_COMPARE),
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
)

Idealistic I would like to choose a value from the first table and then that value gets compared to a static day (today) in the second table, is this even possible in power bi?

3 REPLIES 3
Super User III

## Re: Comparing entire row in table

Hi @g_k_k,

What is the structure of your data? How is the model setup? Depending on the configurations the answer will be different.

Regards

Miguel Félix

Proud to be a Datanaut!

Check out my blog:

Power BI em Português

Super User IV

## Re: Comparing entire row in table

I think you need to have that many measures. The only thing is if you need to change % only. You can create prior measure as var in that formula.

In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin

Frequent Visitor

## Re: Comparing entire row in table

Thanks for your quick reply. Is there a way to make one measure from the two measures i'm currently working with?

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors