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 😀
@iBiTomi
Жыл бұрын
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
Жыл бұрын
I have a Time table ( similar to date table ) with the Tariff marked against each hour of the day
@iBiTomi
Жыл бұрын
@@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
Жыл бұрын
@@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
Жыл бұрын
Actually, just check out this video kzitem.info/news/bejne/uIBmtoSBkHp7g6Qsi=1WmYiUUbCd3riKb_
@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. kzitem.info/news/bejne/pomX1mqmrYhpmX4
@wmanacay
Ай бұрын
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
@AccessAnalytic
Ай бұрын
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] )
@wmanacay
Ай бұрын
Thanks again so much..sorry I still can't work it out. Is it possible to email it? Thanks again
@AccessAnalytic
Ай бұрын
Maybe try posting to www.reddit.com/r/PowerBI/ , you’ll get a quicker response
@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. kzitem.info/news/bejne/pmZj2Wluk5GDhpw
@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.
Пікірлер: 21