What is Selected Value in Power BI DAX Tutorial (26/50)
ฝัง
- เผยแพร่เมื่อ 12 ธ.ค. 2020
- What is Selected value function in DAX,
How to Use SelectedValue Function in DAX,
How to select the values Slicer in DAX and use it as a filter in calculations,
Power bi dax tutorial with examples
#PowerBI #PowerBITutorials #SelectedValue
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da... - วิทยาศาสตร์และเทคโนโลยี
![BOWKYLION - เจ้านายคะ (work-life imbalance) [Official MV]](http://i.ytimg.com/vi/6bFj8G2pOi4/mqdefault.jpg)
This was an incredible example. Nags please keep adding a REAL TIME SCENARIO based Question and Answers too.
Sure thanks keep learning
Yaa , today I did one aggregate with selected value, but based on requirements we have to think Function n logic
Hi Nags, I have a question like , did we make relationship between Sales table and our newly created MonthList table and if no then how it is filtering sales amount with the newly created month filter...
Thanks for the great example.
thanks , keep learning
Good explanation, subscribed
Cheers. Keep learning
so usefull sir,keep upload pls
Thank you, I will . Keep Learning
Please provide dataset in the description box.
Thanks for good topic
Welcome
Thanks a lot 🙏
Thanks keep learning. Share this channel with friends and colleagues
Super. I understand
Keep learning
How do you hide those 3 options incl the three dot ellipsis when hovering a dashboard on some visuals like card, slicers, textbox, tables, etc. Are there any fancy or creative way of hiding those settings?
Visual header property
its very much useful function sir.. i would like to clarify my doubt like.. if i have data from June till december and from january till may i dont have data. in a visual it has to show that Data not avalable for jan, Data not available for feb, so on for the first 5 months if we filter by month wise. could you please help me out in this.. Thank You very much in advance sir...
We can’t show text value some members and numerical values other members(months).
You can show custom messages when there is no value in chart. Check the video regarding custom messages in the channel
Sir waiting for it sir if possible then try to upload more than one video plz.
Sure
It's great content...
Sir please share reference data for the practice...
If data is not in the desc, then its simple data you can prepare it yourself in excel for your use.
Good explanation....if you put raw data also good for us..pls add rawdata also
Will upload soon
@@AnalyticswithNags because if you data more people watch your videos... Pls add video wise...
Please start Other Technologies Like ADF, Synapse etc....
Soon we will start it
Sir when we have connected tables in our data, how to get the same result like while filtering particular month will return till that month.
Answer in this video th-cam.com/video/hJLOBvn_f8k/w-d-xo.html
SIr .. Summarize table use chesaru kada so no need to define any relation between DImdate and Sumarize table? How it is going to work in visualization
You should not connect... That is the whole logic....This is called disconnected dimension... You will get selected Value from the disconnected dimension..... Then use that value in the calculations.
in dimdate table, whats the difference between month and monthnum column? if u have data, can u pls share
Month can be Jan, feb. Month no is 1,2,…
Monthno used to order the Month column
Sir without variable
Can we do this same scenario with switch and selected value function.
Please tell me.
Yes. There are different ways to achieve the results. This video main purpose is to showcase when you can go for variable
@@AnalyticswithNags thanks you so much sir
Hi sir , what if i have jan 2021 data and i want previous months like say nov 2020 and dec 2020 , will this work in that case ?
Use previousperiod or dare add function. Check in Dax playlist
But would it work for a text value ? Like for eg i want previous month rating which is like AA,B etc
sir we created month list table right? why dont we refere monthlist or month number from that table,why you used dimdate table while filtering in calculate function
Already used the selected value variable in calculations
Hi Sir,
I need a help as i am new to power bi, how can we do the same for week wise filter, i want to show last week performance basis on the week filtered, is it possible to do so??
Soon I will make a video on this
@@AnalyticswithNags I want to take complete package of power bi, i liked the way you teach/explain. Let me know if you provide online classes of the same and fees
Hi sir, the selected value is working good with only one selection in a filter but which function i can use for more than one value is selected in filter please let me know sir
Use switch function
Explore the similar problems here, learn.microsoft.com/en-us/answers/
Is there in power BI any Dax wherin we can find out our requiment
Requirment : i have entire 2023 sales data in power BI, in the comparison chart i want se current month vs last month sales ,if i will select Dec month then chart should be Nov vs Dec only
Please let us know sir if you have any idea on this?
Explore the similar problems here, learn.microsoft.com/en-us/answers/
how did it work without even completing calculate loop
Not source about your question
Sir maku sales table meru echina data lo ledu kada
Didn't understand what you are trying to say
@@AnalyticswithNags
Hai sir please send me the source file