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