Default Report to Latest Fact Date in Power BI DAX Tutorial (27/50)
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- How to default the report to Latest Data in Fact Table from data warehouse ,
Show Only Current Month data in Power BI using dax,
Based on Filtered value show the filter data,
Power bi dax tutorial with examples
#PowerBI #PowerBITutorials #FilteredValue
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
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...
Hello All, This is most reliable resources (TH-cam channel) for Power BI and/or Data analytics. Instructor is very knowledgeable and humble. Thank you Nag( Dear Sir).
Thanks for your feedback. If you are in LinkedIn talk about this channel and tag Nagendira KG
Nice explanation
Thanks and welcome
Hi All,
Can't we use ALLSELECTED to get the Date and apply the filter in CALCULATE?
Latest Sales Amount =
VAR MaxSalesDate = CALCULATE(MAX(Sales[OrderDate]), ALLSELECTED(Sales[OrderDate]))
RETURN
CALCULATE(SUM(Sales[SalesAmount]), Sales[OrderDate] = MaxSalesDate)
Hi Nag,
Good explanation.
i have a query, by default we show max date data, but if user wants to see slicer end date data if it falls below max date.
How can we achive it.
Appreciate if you could please explain.
Thanks
Slicer should be always not more than max date in fact.
Hi Nag, i have a requirement like
Set my landing page in power bi for example i have to open my report today and want to see today's data in all the visualisations.
Thanks in advance
You can apply same logic. Instead of fact max date. Use the today dax function
I am havingone problem that i get only lates month sales even for the product category chart
Which base data your using?
Check description of the video. If not exists use your own dataset
Can we use SELECTEVALUE instead of ISFILTERED ?
Yes.
@@AnalyticswithNags Thanks, Great video. I have learned DAX from your video series and has helped me lot in my projects. Thanks for putting efforts in creating the playlist and sharing your knowledge.