@@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.
@@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]
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.
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. ua-cam.com/video/ESap6ptV8fI/v-deo.html
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
Hi again, thank you so much for your videos. Can you please help me with my requirement? I need to get a daily count of records per selected month or months. I also need to get the minimum count and maximum count in a month to colour the graph. How do I do this please? Thank you so much again
If 1 row is a record then COUNTROWS gives number of records per month. For average daily divide by distinctcount of record date ( from Fact Table ) Not sure how you’ll use it to colour graph but Try MAXX( VALUES(Fact[Record Date], COUNTROWS[Fact] )
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. ua-cam.com/video/E0-s58Z_RSg/v-deo.html
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.
Thank you for sharing the video.
You're welcome
Thanks Wyn, great video!
Cheers Chris, glad you liked it
Succinct presentation. Thanks for sharing.
Glad it was helpful!
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
I have a Time table ( similar to date table ) with the Tariff marked against each hour of the day
@@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.
@@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]
Actually, just check out this video ua-cam.com/video/WJ0PPKWHJPo/v-deo.htmlsi=1WmYiUUbCd3riKb_
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.
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. ua-cam.com/video/ESap6ptV8fI/v-deo.html
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
That’s one for the community.powerbi.com/t5/Desktop/bd-p/power-bi-designer forum I’d say 😀
Hi again, thank you so much for your videos. Can you please help me with my requirement? I need to get a daily count of records per selected month or months. I also need to get the minimum count and maximum count in a month to colour the graph. How do I do this please? Thank you so much again
If 1 row is a record then COUNTROWS gives number of records per month. For average daily divide by distinctcount of record date ( from Fact Table )
Not sure how you’ll use it to colour graph but
Try MAXX( VALUES(Fact[Record Date], COUNTROWS[Fact] )
Thanks again so much..sorry I still can't work it out. Is it possible to email it? Thanks again
Maybe try posting to www.reddit.com/r/PowerBI/ , you’ll get a quicker response
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.
ua-cam.com/video/E0-s58Z_RSg/v-deo.html
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.