cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
g_k_k
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? 

 

Capture3.PNG

 

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
Highlighted
Super User III
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.

 

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog:

Power BI em Português





Super User IV
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.





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
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


g_k_k
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?

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

April 2020 Community Highlights

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

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors