Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.    ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous  please provide some sample data and expected output.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, Let's see.. 

     

    The below would be a simplified verison of the daily product made for each site, in the final version I would like to input a table with many more rows for each site. 

    Restaurant 1Coffee20/11/2021

    Restaurant 1

    		Cake20/11/2021
    Restaurant 2Coffee20/11/2021

    Restaurant 2

    		Cake20/11/2021
    Restaurant 3Coffee20/11/2021

    Restaurant 3

    		Cake20/11/2021
    Restaurant 4Coffee20/11/2021

    Restaurant 4

    		Cake20/11/2021

     

    Group List

    Restaurant 1Group 1
    Restuarant 2Group 2
    Restaurant 3Group 3
    Restaurant 4Group 1

     

    And the price list

    FoodGroup 1Group 2Group 3Group 4
    Coffee£1£1,20£1,10£1,30
    Cake£2£2,20£2,10£2,30

     

    So I would like to create some chart to show how much each site has made £ each day, based on the group they belong to which determines the price for each item.

     

    I hope this makes sense