cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Anonymous
Not applicable

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

MFelix
Super User III
Super User III

Hi @Anonymous,

 

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 Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.