Great video Wyn, and thank you for sharing it. I wonder f you are going to cover how you created different electricity tariffs over the year
@AccessAnalytic11 ай бұрын
I have a Time table ( similar to date table ) with the Tariff marked against each hour of the day
@iBiTomi11 ай бұрын
@@AccessAnalytic , can you please give me a bit more details on how you created the tariff column in the date table. Thank you in advance for your response.
@AccessAnalytic11 ай бұрын
@@iBiTomi just an IF fomula against my time table = Table.AddColumn(PreviousStep, "Tarriff Band", each if [1 hour bucket] >= 9 and [1 hour bucket] 15 and [1 hour bucket]
@AccessAnalytic11 ай бұрын
Actually, just check out this video kzfaq.info/get/bejne/jbBgg7N8vK6ugKM.htmlsi=1WmYiUUbCd3riKb_
@readistreet9383 Жыл бұрын
Hi great video. Can you make please a video for calculating de difference of sales for example between working days? i have the problem on monday that dax look back at sunday when i need to calculate the difference with friday not sunday
@AccessAnalytic Жыл бұрын
That’s one for the community.powerbi.com/t5/Desktop/bd-p/power-bi-designer forum I’d say 😀
@bagadojisolomon9808 Жыл бұрын
This is a great video. Please I will want to know how to calculate monthly total of data that span up to 10 years. I want to get the sum of each month for all the years in the data sheet.
@AccessAnalytic Жыл бұрын
I’m guessing your months are in separate columns in your source data? In which case you need to unpivot your Dara and then it should be a simple sum of the unpivotted column. kzfaq.info/get/bejne/e7mRo5mh2bycln0.html
@holahandstrom Жыл бұрын
The reason most struggle with DAX is that Power BI don't Yet have a 'Formula Element Value Preview' - that we have in Excel. If Microsoft would add 'Formula Element Value Preview' (or F9), the Power BI usage would probably double. kzfaq.info/get/bejne/e5Zdpphpv8W2g5s.html
@AccessAnalytic Жыл бұрын
Microsoft did demo something at Microsoft build that can assist in visualising the results of the formula ( like DAX studio) The challenge with DAX is also the formula needs to run in the context of a visual, so what might look fine in the formula bar doesn’t give the same result in the visual.