{"id":3556,"date":"2021-09-06T11:16:47","date_gmt":"2021-09-06T18:16:47","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3556"},"modified":"2021-09-06T11:16:48","modified_gmt":"2021-09-06T18:16:48","slug":"how-to-calculate-number-of-days-between-two-dates-in-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3556","title":{"rendered":"How to Calculate Number of Days Between Two Dates in Power BI"},"content":{"rendered":"\n

Problem<\/strong>:<\/p>\n\n\n\n

I have a table with customer information, including a target start date of the contract and the actual start date. I would like to add an additional column showing the number of days the contract actually started before (negative number) of after (positive number) the target start date. <\/p>\n\n\n\n

Solution1:<\/strong><\/p>\n\n\n\n

You can create a calculated column. Right click on the table, select “New Column”, in the formula section you can use<\/p>\n\n\n\n

Column Name = 1. * (Table[actual start date] – Table[target start date])<\/p>\n\n\n\n

This should give you a negative number of days between the two dates.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Solution2<\/strong>:<\/p>\n\n\n\n

you can create a measure by using a similar formula as solution 1. <\/p>\n\n\n\n

<\/p>\n\n\n\n

Solution<\/strong>3: <\/p>\n\n\n\n

You can also use the Dax expression DatesBetween Documentation is found here<\/a>.<\/p>\n\n\n\n

Days Between = DATESBETWEEN( ‘Table'[Dates], ‘Table'[Start Date], ‘Table[End Date] )  <\/p>\n\n\n\n

This will return a single number for the number of days between the two dates.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Ref: https:\/\/community.powerbi.com\/t5\/Desktop\/calculate-number-of-days-between-2-dates\/m-p\/51213<\/p>\n","protected":false},"excerpt":{"rendered":"

Problem: I have a table with customer information, including a target start date of the contract and the actual start date. I would like to add an additional column showing the number of days the contract actually started before (negative number) of after (positive number) the target start date. Solution1: You can create a calculated Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[838,837,839],"class_list":["post-3556","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-number-of-days-between-two-dates","tag-number-of-days-between-two-dates-in-power-bi","tag-number-of-days-power-bi"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t