"ask a question"
2 Topics
How to create periods with date ranges
Hi! I'm just starting PowerBI and need some help on a formula. I have five columns: site, date, energy, consumption, average unit price and cost. I would like to create 6 different periods with ranges of dates, like May 2021 to July 2022 for instance. How can I do this to have one row per site and type of energy, with consumption and cost totals; and average unit price for each period? For example: London | May 2021-July 2022 | Electricity | total consumption over the period | average unit price over the period | total cost over the period London | May 2021-July 2022 | Gas | total consumption otp | average unit price otp | total cost otp Mainly, is it possible to do it with a formula? I followed courses but didn't find the answer; that's why I wanted to ask here. Thank you!Solved959Views0likes4Comments
Rank
I have a table with the name of the branch, the sales department, the seller, and the value of each sales invoice. I created a standard for net sales and put it on a card, and it works well. I want to create a standard by arranging each seller according to his sales for the branch to which he belongs, so that if I select him from a table or visual, his order will appear.Solved729Views0likes2Comments