Calculate difference between 2 (Two) dates in Power BI Power Query

Опубликовано: 21 Октябрь 2024
на канале: Pettaka Technologies

35,647

254

Learn how to calculate difference between 2 (Two) dates in Power Query of Power BI. In Power Query, calculate difference between 2 two dates or 2 column dates & show two 2 dates difference. You will get more videos like this in Power BI Power Query M Functions Tutorial Series ‪@PettakaTechnologies‬
=========================================================
#tutorial #powerbi #pettakatechnologies #powerquery #mfunctions
=========================================================
***************Steps To Follow***********************
1) Data source should contain two dates column.
2) Go to Power Query editor, select "Add Column" from tab.
3) Select "Custom Column" to add a new custom column.
4) "Add Custom Column" dialog box appears.
5) Rename you new "Custom Column"
6) Enter Power Query M Function "Difference.ToRecord" and select two columns.
7) Expand "Difference" Column to get date difference in days, hours, minutes & seconds.
========================================================
Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies. Power BI Tutorial for Beginners 2020.
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