🙋 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.....
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!
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
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.
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!
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.
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.
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.
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!
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.
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
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!
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.
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!
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!
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.