Forum Discussion
Calculating Daily Totals based on helper sheets
Hello, I am very new to Power Bi but really enjoy it so far. I have a good level of knowledge with Excel pivot tables etc but I want to challenge myself and get to know this software more. ...
Hi Anonymous ,
Please have a try.
Create a column.
Column = CALCULATE(MAX('price'[Value]),FILTER('price','price'[Food]=EARLIER(Restaurant[type])))If I misunderstand your meanings, please provide more than two days' data and expected output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please have a try.
Create a column.
Column = CALCULATE(MAX('price'[Value]),FILTER('price','price'[Food]=EARLIER(Restaurant[type])))
If I misunderstand your meanings, please provide more than two days' data and expected output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.