Column From Examples - Power BI Desktop Tips and Tricks (31/100)

What is Column from Example in Power Bi
How to derive a column in power Query using column from example
Derive a column in power query without M code
One of coolest feature where need to specify , how you need the output and power query will give you the Code
#PowerBI #PowerBIDesktop #PowerBITutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 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...

[@pnadig]

I have data in 2 table. 1st table has data month wise in row. And second table has data month wise in column. Is it possible to merge both the table to prepare matrix table

[@AnalyticswithNags]

Watch this three videos, that will solve your problem kzbin.info/www/bejne/pKaUapeveN-Ii7c kzbin.info/www/bejne/lZ2nnJudmteorbc kzbin.info/www/bejne/hWicdYWbh5ulpas

[@yes-pg5dy]

Can we change a column header in matrix visual dynamically without using a slicer? Is it possible sir?

[@AnalyticswithNags]

Can you elaborate. Not able to understand your exact requirements

[@yes-pg5dy]

@@AnalyticswithNags I have two tables one is date table and another supplier details tables. Now I want to create a matrix visual in which 3 columns must be there first column is supplier names and second column is current month-year (May-2021) and third column name must be previous year same month(May-2020)... I created a slicer which contains year-month column values from the date table. Now in slicer if I select May-2021 then in the matrix visual i need to see the second column as May-2021 and the third column as May-2020... This is my requirement sir

[@yes-pg5dy]

@@AnalyticswithNags by using the following Dax formula Value in Matrix = IF ( SELECTEDVALUE('Table'[Date]) = DATE(YEAR(MAX('Slicer'[Date])),MONTH(MAX('Slicer'[Date]))-1,1), SUM ( 'Table'[Sales] ), BLANK () ) I am getting May-2021 and April-2021 as column names but my requirement is May-2021 and May-2020 as column names