🙋 bro your videos are very helpful 👍 I have some doubt : I think for MOM% the calculation would be Divide( CurrentMonth - PreviousMonth / PreviousMonth ) instead of Vairance - PreviousMonth ? & I want to know that you have done 13 videos of ADF is it enough to get entry level job.....
@AchieversDataEngineering
5 ай бұрын
Hi @Mahesh717, Yes, you are correct it should be Divide( CurrentMonth - PreviousMonth / PreviousMonth ). Regarding ADF videos, It may not be sufficient but definitely a good way to start. Thank you for watching!
@shabimosesa9123
8 ай бұрын
It's interesting, but the only problem is that I can't see the dax expression you type , you should zoom out the functions so we can follow
@AchieversDataEngineering
8 ай бұрын
Sure! Thank you for watching! I hope it was helpful.
@alghbashnehmohammad9597
3 ай бұрын
When i add the verince it summrozed by sum so the % not reflected right i tried to change it to non summrized but it is not availbe it mandatory to selcet one choice sum ,avg ,medin ,, how i can fix this issue
@namitamehta8896
Жыл бұрын
I have May- Sept customer data in excel and need to make weekly dashboards based on metrics ,How can I approach that
@AchieversDataEngineering
Жыл бұрын
Hi @Namita, Based on date column, first you can create a Week number column using WEEKNUM Dax. Then based on this you should able to proceed for further calculation. Thank you for watching.
@aayushshrestha1655
2 жыл бұрын
HI Sir, can you please provide this excel sheet so that I can practice along with the tutorial. Thank you
@AchieversDataEngineering
Жыл бұрын
Hi Aayush, Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too. Mean while there are various open sources from where you can get free data to learn and test your visuals. below are a few- data.europa.eu/en databank.worldbank.org/home.aspx www.data.gov.uk/ Hope it will help! Keep learning!
@koteswaribapatla8075
2 жыл бұрын
Hi,here i want to divide previous month sales with previous month number.can advise me how to write with dax formula.thanks
@AchieversDataEngineering
2 жыл бұрын
Hi koteswari, You can use variables in the Dax. var1 sales previous month sales var2 monthnum = previous month number return sales/monthnum
@ParikshitJoshi-y8d
7 ай бұрын
Thanks. It was very easily understandable and smooth while implementing.
@AchieversDataEngineering
7 ай бұрын
Great to hear! Thank you for the appreciation!
@putrijuniarti376
2 жыл бұрын
Hey, I've try your formula but my dashboard can't show the previous value probably because my date data is not continuous (updated only once per month, for example date input on 01/01/2022 next data will be on 01/02/2022). Any suggestion to solve this? It's work well only if using Year or Quarter date hierarchy.
@AchieversDataEngineering
2 жыл бұрын
It should work well even if there is any single date of any month. As a workaround try creating a Date table; connect the date table with the Date column in your main table and then use the date table's date in all related DAX. Also please check "Auto Date & Time intelligence option is on by going into File--Options & setting---Options--Current File--Data Load--"AutoDate/Time". Please let me know if you still face any challenges.
@reteshp1170
16 күн бұрын
Hi Great video! Do you have any examples where you are comparing a months from the current year and previous year? If I select the year 2022 and month September then it should compare the data between September 2021 and September 2022.
@AchieversDataEngineering
16 күн бұрын
Thank you! we can such view using below process- 1) Create single select slicer for year and month. 2) Create measure for selected value to get selected year and month 3) Create same period last year DAX and use selected year and month value as variable from above DAX, to get the last year/month value. Hope it helps. Thank you!
@unitedwings7644
Жыл бұрын
Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that
@AchieversDataEngineering
Жыл бұрын
Hi, That's interesting, let me try.I will share my findings with you soon. Mean while if you can provide sample data to replicate exactly the same issue your facing will be better.
@pl4195
2 жыл бұрын
When compare month, how can I add two dropdown allow me to choose which two months I would like to compare with. for example, Jan vs June instead of June compared to last month only Thank you
@AchieversDataEngineering
2 жыл бұрын
Hi @PL, sorry for the delayed response. You can try below two approaches which ever satisfy your requirement- 1) Try horizontal month slicer with multiple selection option. So if you'll select two any two months graph will show data for only those months. 2) Try creating copy two similar charts and two month slicers. With help of edit interaction limit the interaction of each slicer to one chart only. Now you can format both chart in same look and feel. Add some comments which will prompt user to select months in both slicers to compare with each other. Lets me know if it worked Or if you have already did it with better solution. Thank you!
@sunilvarma9547
2 жыл бұрын
Hi , thanks for your detailed video. I created the same chart with latest 12 months comparison with previous year , While hovering the above bars for Current year Month bar and previous year month bar , what if i need to show the light blue bar as 2012 while hovering on the light blue bar and when hovering on the Dark blue it should show hover the values as 2011. Could you pleas suggest. For now while hovering both the bars show as same N0V-2021 as i have taken by x-axis with MMM-YY.
@AchieversDataEngineering
Жыл бұрын
Hi Sunil, Yes, It is can be done in power BI. We have got options to customize the tooltip.
@Juggatweet
Жыл бұрын
I'm trying to create a visual to compare units sold in one month to the same month the prior year, I think this will work if I adjust the interval in the measure. Would slicers work to add skus and variations so I can focus on certain products or groups? I found the video helpful and easy to understand thanks!
@AchieversDataEngineering
Жыл бұрын
Thank You @michele. I'm glad it helped.
@NewChannel-u4r
11 ай бұрын
How to calculate sales per week without creating new column?
@AchieversDataEngineering
11 ай бұрын
Hi, It would be easy and better both to have a week column to calculate sales per week. Thank you for watching!
@Ayuk1
2 жыл бұрын
Very insightful. Thanks for sharing your knowledge. Do you think the Y axis Values should be turned off since your chart now includes data labels?
@AchieversDataEngineering
2 жыл бұрын
Thank you Arung! Yes, values can be turned off as bars are showing data labels.
@k333ys2
Жыл бұрын
Thank you for the amazing breakdown of this chart VERY INSIGHTFUL!
@AchieversDataEngineering
Жыл бұрын
Thank you for watching. I'm glad it helped.
@mariapradeepm
10 ай бұрын
How to show the same period last year's month name as well in bar chart when we hover it?
@shaheenP1196
2 жыл бұрын
Dint understand u used Dax functions
@AchieversDataEngineering
2 жыл бұрын
Hi Ss, Which DAX function you could not understand?
@PriyankaBhatnagar-q3g
Жыл бұрын
I'm getting incorrect graph.. its not showing 3 bars for 3 years, instead showing the variance between highest and lowest sales between the 3 periods
@AchieversDataEngineering
Жыл бұрын
Thank you for watching! Please see if you were using correct chart type.
@AndyPrice-h2y
2 ай бұрын
Fantastic explanation - thankyou.
@AchieversDataEngineering
Ай бұрын
Thank you!
@manasasakam9741
2 жыл бұрын
n u pls provide this pbix file
@AchieversDataEngineering
Жыл бұрын
Hi Manasa! Thank you for watching. It is not now possible now but in future videos I can make sure to upload a link to dataset too. Mean while there are various open sources from where you can get free data to learn and test your visuals. below are a few- data.europa.eu/en databank.worldbank.org/home.aspx www.data.gov.uk/ Hope it will help! Keep learning!
@share2beu
Жыл бұрын
it worked well. thank you!
@AchieversDataEngineering
Жыл бұрын
Thank You! @Beulah
@ericpad
Ай бұрын
Excellent tutorial! Very helpful!
@AchieversDataEngineering
Ай бұрын
Thank you!, I'm glad it was helpful!
@dnyaneshwarudhare1074
3 ай бұрын
thanks
@AchieversDataEngineering
Ай бұрын
Thank you for watching.
@shivasai25
2 жыл бұрын
How can we give the colouring for data label based on high and low
@AchieversDataEngineering
2 жыл бұрын
Hi @Shiva, You can go into format visual section, select column color there you define rules or select gradient color for the columns based on column value. Hope it helps.
@shivasai25
2 жыл бұрын
@@AchieversDataEngineering yes it is helpful Thanks for the reply
@youngchi968
Жыл бұрын
Thank you so much!!!
@AchieversDataEngineering
Жыл бұрын
Glad it helped!
@youngchi968
Жыл бұрын
@@AchieversDataEngineering Do you have a video on how to calculate YTD Monthly Average?
@brunovanherpe8423
7 ай бұрын
thanks a lot for the wonderful explanation
@AchieversDataEngineering
7 ай бұрын
Glad it was helpful!
@shoaibrehman9988
Жыл бұрын
Awesome
@AchieversDataEngineering
Жыл бұрын
Thank you Shoaib! Keep Learning!
@mohitjain3606
2 жыл бұрын
Nice
@AchieversDataEngineering
2 жыл бұрын
Thank you Mohit!
@Summane
2 жыл бұрын
Thank you ! works like a charm
@AchieversDataEngineering
2 жыл бұрын
Hi @Karma, Great to hear this. I'm glad it helped.
Пікірлер: 62