Power BI Power Query to Calculate Difference Between Two Dates in Number of Days
Power BI Power Query tutorial on how to calculate difference in days using the m function for date column in a table. You will get more videos like this in Power BI Power Query M Functions Tutorial Series @PettakaTechnologies
============================================================
#tutorial #powerbi #powerquery #mfunctions #PettakaTechnologies
============================================================
************************Steps To Follow***************************
1) Data source should contain two dates column.
2) Go to Power Query editor, select end date and start date columns.
3) Click on 'Add Column' from tab.
4) Expand "Date" option in "Add Column".
5) Choose "Subtract dates" from "Date" options.
6) You got number of days between two dates in Power Query.
7) Rename your new "Custom Column"
============================================================
Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies. Power BI Tutorial for Beginners 2022.
Power BI by Pettaka Technologies.
Data Cleaning with Power Query of Power BI.
Data Visualization with Microsoft Power BI.
============================================================
Playlists:
Microsoft Excel : • MS Excel Tutorial
Excel VBA Macro : • Playlist
Power BI : • 🚀 PowerBI Tutorial for Beginners 😎
Power BI DAX Tutorial : • Power BI DAX Tutorial
============================================================
Connect with us:
Subscribe | / pettakatechnologies
Facebook | / pettakatechnologies
LinkedIn | / pettaka-technologies
Twitter | / pettakatech