Can you solve this query, Write dax measure for running total which should display only till actuals are available Ex : there is data with plan vs actual. Plan are there for 30 days and actuals only for 10 days, so in the visual it should display actual vs plan running total only till 10th Note : Actuals and planned values are in same table
@nivi54762 ай бұрын
this is not working for me. you used total sales .my requirement is percentage value divide count of id from table 1 and count of id from table 2 ..thus is my value its not working. please help me
@avinashnl95882 жыл бұрын
Hello Team, it's a very good video and appreciate your support on my issue which has a similar requirement i.e. want to display values for the current year upon selection of date. ex:- if I select today(5/08/2022) in the chart it should display all the values till this 1st of Jan 2022 based on month-wise segregation. Thanks in advance
@srikanth73687 ай бұрын
Amazing video. This video has solved my real time issue. Please let me know if your offer any course.
@Alan.DL7 Жыл бұрын
Word of advice, do a reference to the guys who came up with this solution. Your video is just an exact copy/paste of what SQLBI did. Nothing wrong with spreading the word and the solution but only if you give a shout out to those who actually did it first. SQLBI video: kzbin.info/www/bejne/mmm1nmqarLJpncU
@anuninan664 Жыл бұрын
Not working for me
@Nextwhatguru11 ай бұрын
Thank you Mi Tutorials
@sarabashi1269 Жыл бұрын
Hi, Can you tell me if I want to do -13 week is itpossible with this way? I can not add Week instead of Month in your formula
@thepucpcinogrumpycat69752 жыл бұрын
Exactly what I needed. Thank you Sir
@sarihaddu4 ай бұрын
I have data sales data upto March 2023 but the calendar table has dates up to December 2023. When I don't select any month is slicer, the column chart is empty. How to remove months from Slicer which don't have any corresponding sales data? I don't want April 2023-Dec 2023 to show in slicer here.
@MITutorials4 ай бұрын
There are multiple ways of doing this - try to add the sales filter and choose to display non blank sales.
@sarihaddu4 ай бұрын
@@MITutorials Got it. Thank you so much.
@MrRanggoy6 ай бұрын
Hi Question, what if I selected Dec 21 but I want to calculate will be start in Nov, Oct, Sep, Aug, Jul and Jun 21
@nachikettikekar29037 ай бұрын
How to show the same in matrix visual? I want to show date and sales in the VALUE of matrix.
@ankitprajapati3208 Жыл бұрын
What if I want to add any dimensional column from Order Table in visual.
@shraddhaverma47955 ай бұрын
Of there is no sales data and if i want to filter all table how can i do that
@sureshrao1742 жыл бұрын
Thank you but, How to write Dax If I select a month in slicer I need to sales chart month wise from Financial year starting I mean from April. No matter which month I select I need sales data from April of the same fiscal year. Pls guide
@iira1311 Жыл бұрын
Thank you for the solution but my Date field hierarchy gets removed which is creating problem for slicer, Any solution on that?
@user-fb1zf7kq7m Жыл бұрын
is it possible to do same thing in Excel with Power Pivot?
@user-je9yp3vp5w Жыл бұрын
Hello. Nice job. How could i do the same but for years. For example if i choose 2023 i want to display 2023 2022 2021 2020 2019
@MITutorials Жыл бұрын
Change the Interval from Month to Year in the Dax.
@diazjubairy17292 жыл бұрын
if i we want to make another measure in different visualization, does it mean we need to create another slicer for that new visualization ?
@MITutorials2 жыл бұрын
If it's a new measure then yes you need another slicer.
@janardhanreddy49622 жыл бұрын
Nice
@harichandrareddysagili7700 Жыл бұрын
Can share the powerbi which you worked, I am also trying but unable get the tren for 6months
@sampathkumarkumar50712 жыл бұрын
how to exclude current year in matrix actually same formula i followed but i need not to show current year data
@Sah-dd1zhАй бұрын
Yep… doesn’t work for me at all.
@vibhors50 Жыл бұрын
Helpful video. How and where can we download the csv file for orders from ?
@MITutorials Жыл бұрын
Please see the dataset below. docs.google.com/spreadsheets/d/1nIBLpCvdVcM2dsec7kGlkjSri92MkImg/edit?usp=share_link&ouid=104221769290538600399&rtpof=true&sd=true
@ErcoGardiner Жыл бұрын
hart line months not sorting correctly , I dont know why
@SEVideoQuant Жыл бұрын
Where can we get the pbix file to play with the concept. Thx
@arokiarajan12302 жыл бұрын
Thank you..
@gaetanomanino1932 Жыл бұрын
Hi how can i make it cummulative? Like the 6 months but with running total
@MITutorials Жыл бұрын
Please watch this tutorial. How to Calculate Running Total / Cumulative total over Years and Months in PowerBI | MITutorials kzbin.info/www/bejne/laHNqIeVgJubibc
@jholwol26998 ай бұрын
somehow even after following all the steps i am unable to get the result
@ankurarora76324 ай бұрын
when i am clicking on slicer, it shows only that particular month data. its not showing last 6 months
@sarihaddu4 ай бұрын
Post the dax formula here
@ankurarora76324 ай бұрын
it worked. thanks@@sarihaddu
@mananshukla5001 Жыл бұрын
Can you link the video on how to create the Calendar Table
@MITutorials Жыл бұрын
How to Create Calendar Table using DAX in PowerBI | MI Tutorials kzbin.info/www/bejne/hZinYYGggMqKerc
@sakibzamanmohammad8895 Жыл бұрын
How can we do the same in excel....please help.
@ankurarora76324 ай бұрын
can you please share the pbix file
@thompham8903 Жыл бұрын
thăn kiuuuuuuuuuuuu
@xcelskills646 Жыл бұрын
How to get the last 4 weeks data based on slicer selection