Choose Function in Excel
5:34
4 ай бұрын
USERELATIONSHIP Function  in DAX
6:43
Spilled Array Excel Trick
9:27
4 ай бұрын
Power BI Course Announcement
5:32
Keep Filters DAX Function
8:34
7 ай бұрын
Calculate and Filter Function
22:30
Context Transition in DAX
15:05
7 ай бұрын
Related DAX Function
13:25
7 ай бұрын
Power BI Field Parameters
7:14
10 ай бұрын
Пікірлер
@rajan2699
@rajan2699 Күн бұрын
🎉❤
@sumitrawat4103
@sumitrawat4103 6 күн бұрын
kindly provide these report for practice
@SimpleAnalysis
@SimpleAnalysis 3 күн бұрын
Sure.
@sumitrawat4103
@sumitrawat4103 3 күн бұрын
@@SimpleAnalysis How can i get dataset
@pradeepkumarr7031
@pradeepkumarr7031 9 күн бұрын
hats off to you sir, the way you are explaining is extraordinary, i refereed many you tuber's vides, but literally you explained in most genius way.... i became your fan
@SimpleAnalysis
@SimpleAnalysis 9 күн бұрын
Thank you. This means really to me
@rajeshr5767
@rajeshr5767 16 күн бұрын
Thank you so much for this tips, this really work so well.I was searching lots videos in last two days and they are all making so conplicated like linking another table, enter data new data sets etc... But yours were so simple and worked. Thanks tons. 🎉😊
@SimpleAnalysis
@SimpleAnalysis 15 күн бұрын
Thanks and glad you like it.
@anujasule8077
@anujasule8077 27 күн бұрын
This is what exactly i was looking for my project. Thank you so much , You are awesome
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
You are welcome 😊
@yogeshkharat7828
@yogeshkharat7828 28 күн бұрын
Thank You sir for great content.feedback - please increase volume not able hear properly.
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
Noted
@mahesagilang5850
@mahesagilang5850 29 күн бұрын
Isnt it unlikely to have previous ID collumn like this?
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
ID May be unlikely. but think in a table we have emp & mgr best self join scenario
@mahesagilang5850
@mahesagilang5850 29 күн бұрын
Can u explain why ppl need to know how many days since a certain customer last order to the last order date? Instead of todays date
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
Order when last occur it can be always current date
@amitgajkal4821
@amitgajkal4821 Ай бұрын
Please share the data set it will be helpful
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
Yes i am planning to create drive for all datasets for all my videos
@paraskurele6340
@paraskurele6340 Ай бұрын
Thanks
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
Welcome
@tanajisulagave
@tanajisulagave Ай бұрын
Hello Sir Nice Contents, very helpful, can you please share the sources for this
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
Yes i am planning to create drive for all datasets for all my videos
@tanajisulagave
@tanajisulagave 24 күн бұрын
@@SimpleAnalysis Thank you Sir. Please confirm once done
@Slayonus
@Slayonus Ай бұрын
I tried your exact steps, somehow it is not working for me either. The transparent color is not transparent but stays white.
@SimpleAnalysis
@SimpleAnalysis 26 күн бұрын
if you could share your pbix that woud be great
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
drive.google.com/file/d/1SGQl9EeghtI4bUUO2E0YhFllBgRjm5N7/view?usp=sharing :- Pbix File
@nilimagoyal
@nilimagoyal Ай бұрын
Very nice explanation
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Glad you like it
@anillpatel
@anillpatel Ай бұрын
Very good tips Thanks.
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Thank you
@wessauder7708
@wessauder7708 Ай бұрын
Great Tutorial! Well done.
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Glad you like it
@ngochanhuynh1295
@ngochanhuynh1295 Ай бұрын
can i get the dataset please?
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Sure will attach dataset for all scenarios
@f2004500
@f2004500 Ай бұрын
Can't First day of sale be done by min(Date of sale) rather than creating a new column?
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
As per filter context all dax calculation works so only Min( date) will not work everytime
@kebincui
@kebincui Ай бұрын
Very good explanation. Thanks 👍
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Glad you like it
@ManoharNutoh
@ManoharNutoh 2 ай бұрын
Thank you for the video. What if the Visual is Guage instead of Bar chart?
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
It should work ..please have a try and let me know
@PravinKalbhor-he7qf
@PravinKalbhor-he7qf 2 ай бұрын
what if we have some duplicate entries in total spend column it skip the rank
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
May be dense rank should work.hefr need to test though
@yogeshkharat7828
@yogeshkharat7828 2 ай бұрын
hello sir can you please share sample data so we can practice parallel
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Just allow me sometime to provide a dataset.
@yogeshkharat7828
@yogeshkharat7828 2 ай бұрын
Best content on PowerBI
@SimpleAnalysis
@SimpleAnalysis Ай бұрын
Thank you
@cimoalpacino
@cimoalpacino 2 ай бұрын
Great tutorial, thanks! Works like a charm 🥳
@SimpleAnalysis
@SimpleAnalysis 2 ай бұрын
Glad you like that
@awololarukayat4481
@awololarukayat4481 2 ай бұрын
Found this when I needed it . Thank you
@SimpleAnalysis
@SimpleAnalysis 2 ай бұрын
Great.
@vlrrao6538
@vlrrao6538 2 ай бұрын
Could you please provide data set, it will be helpful to us to practice. 1 million times thanks.
@SimpleAnalysis
@SimpleAnalysis 2 ай бұрын
Sure
@vlrrao6538
@vlrrao6538 2 ай бұрын
You are the Super. Everywhere we can find the Dax function and it's use but here only we can get Scenario based explanation in detail. Awesome explanation with patience. Thanks a lot.
@SimpleAnalysis
@SimpleAnalysis 2 ай бұрын
Glad you like it. Keep supporting.
@user-be6yi6zk5d
@user-be6yi6zk5d 3 ай бұрын
Helpful
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Thank you
@chiranjeevivarma8258
@chiranjeevivarma8258 3 ай бұрын
Provide data sets
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
This is very simple data just create an excel.file and make it as source. You can play around the data as well and thi will help to create data set as well
@chiranjeevivarma8258
@chiranjeevivarma8258 3 ай бұрын
Plz provide datasets otherwise it will be useless
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
If you think without data it is useless and you learn nothing from this use case. . Providing dataset is different thing which I will do but it is not useless I believe
@joejogeshwar2346
@joejogeshwar2346 3 ай бұрын
I did all the things you did...but somehow its not hiding...I don't know where did it go wrong
@joejogeshwar2346
@joejogeshwar2346 3 ай бұрын
I got it right till the false part in the cards...then I applied the filter to the chart and changed to "is" and "1" but still nothing has changed.🙃
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Tried again from my end the same procedure and it worked. Please do follow the same
@AnshumanSharma-dl5th
@AnshumanSharma-dl5th 3 ай бұрын
Nice explanation.
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Glad you like it
@unnikrishnansanthosh
@unnikrishnansanthosh 3 ай бұрын
this is what i was searching for, thank you, also is there a way to send alert to multiple users
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Once alert created you can send it to distribution list. And one more thing to add with Fabric Subscription we can create alerts for any visualisation. Newly added feature
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Yes we can send it to distribution list. And newly added feature is with fabric subscription we can create alert for any visualization.
@pallavishahare790
@pallavishahare790 3 ай бұрын
Explanation is very nice. Thank You
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Glad you like it
@pravinkalbhor1655
@pravinkalbhor1655 3 ай бұрын
Can you provide your contact details sir
@Galli-se-office
@Galli-se-office 3 ай бұрын
It’s better please share the data for practice as I saw the maximum KZfaqr are doing the same practice
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Most of the videos will have the link for the dataset in the comment section. If this is missed let me check and update
@priteshsingh03
@priteshsingh03 3 ай бұрын
Thank you, Been on it for 2 days
@SimpleAnalysis
@SimpleAnalysis 3 ай бұрын
Glad you like that
@malaydubey3584
@malaydubey3584 4 ай бұрын
can we set a background color for the whole row if one column is having 1 or 0. Example if one of value in that column is 1 then green on whole row else if 0 then red on whole row.
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
But how you will do that granularity is at month /year level. And checking the value. Maybe we can try something different have some idea let me try and let you know
@208935
@208935 4 ай бұрын
hi sir,along with month, we need WEEK NOs also...How to get WEEK Wise data ...2nd query is , Our weeks are fixed in each month i.e. Dat 1 to7 is 1st wk, 8 to 15 -2nd ,16-23 is 3rd wk, 23 to end of month is 4th wk...Hence we have 48 wks per year...So we want WEEK NOs this way... Is this possible to achieve above 2 queries solution in powerbi?
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
First of all thank you for liking the content. For these two scenarios will definitely comeback to you ASAP.
@TestsPBI
@TestsPBI 4 ай бұрын
Thank you for the content, but do you know if it is possible to have just a subset of pre-selected columns when user runs the report?
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Glad you like that. Let me check other requirement.fod pre-selected columns. Will update ASAP
@777tmack
@777tmack 4 ай бұрын
Nice!
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Thank you
@bimanroy8865
@bimanroy8865 4 ай бұрын
Where is voice?
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Yes some issues with audio. Sorry that I will take care in the near future
@Sirigineedi_Navann
@Sirigineedi_Navann 4 ай бұрын
Useful one brother Thanku so much
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Thank you
@narband2778
@narband2778 4 ай бұрын
Thanks for sharing real time example. Great Job !!
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Glad you like that
@narband2778
@narband2778 4 ай бұрын
@@SimpleAnalysis Bro... How should I contact you ? Need to discuss regarding Power BI.
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Send me details through [email protected]
@prateekkumar-xc6uo
@prateekkumar-xc6uo 4 ай бұрын
Thank you brother for explaining the whole concept. doing really great job. one suggestion could you pls check your audio quality. I have noticed the quality of audio is not clear need to fix it, thanks once again for the expalanation
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Yes I observed the same. Let me check and rectify it.
@Sirigineedi_Navann
@Sirigineedi_Navann 4 ай бұрын
nice one bhai
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Thank you.
@MoonShine-bs6cl
@MoonShine-bs6cl 4 ай бұрын
Hi your videos are amazing but i have one urgent requirement please can you help me at the earliest by making video how to create normal bar and clustered stacked bar chart in excel for 2 years, as normal bar will be totL sales for 2023 and clustered stacked bar should have both sales values and %on sales month wise for 12 months, it would b a great help... Thanks in advance
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Sure will do
@MoonShine-bs6cl
@MoonShine-bs6cl 4 ай бұрын
@@SimpleAnalysis Thank you
@Qwertythemouse
@Qwertythemouse 4 ай бұрын
Another feasible Option would the following one : Most Active Day = MAXX( TOPN (1, SUMMARIZE ( DimDates, DimDates [WeekDayName], "Transactions", [Transactions] ) , [Tran] , DESC ) , DimDates[WeekDayName] )
@monubhaiya9022
@monubhaiya9022 4 ай бұрын
thanks for video sir watching in 2024 helping a lot to solve issue
@SimpleAnalysis
@SimpleAnalysis 4 ай бұрын
Thank you for the kind words
@Sirigineedi_Navann
@Sirigineedi_Navann 5 ай бұрын
Nice one Mishra Bhai 😊. Thanku so much
@SimpleAnalysis
@SimpleAnalysis 5 ай бұрын
Thank you