No video
DAX Help - how to calculate a monthly average from daily or hourly data
Рет қаралды 5,845
Күн бұрын
@Bhavik_Khatri Жыл бұрын
Thank you for sharing the video.
@AccessAnalytic Жыл бұрын
You're welcome
@chrism9037 Жыл бұрын
Thanks Wyn, great video!
@AccessAnalytic Жыл бұрын
Cheers Chris, glad you liked it
@John-gx5hm 6 ай бұрын
Succinct presentation. Thanks for sharing.
@AccessAnalytic 6 ай бұрын
Glad it was helpful!
@iBiTomi 11 ай бұрын
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
@AccessAnalytic 11 ай бұрын
I have a Time table ( similar to date table ) with the Tariff marked against each hour of the day
@iBiTomi 11 ай бұрын
@@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.
@AccessAnalytic 11 ай бұрын
@@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]
@AccessAnalytic 11 ай бұрын
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.
Access Analytic
Рет қаралды 2,4 М.
Enterprise DNA
Рет қаралды 39 М.
Bulldog Analytics
Рет қаралды 7 М.
Access Analytic
Рет қаралды 70 М.