topic Re: differnce dates with sum in DAX Commands and Tips

differnce dates with sum

Talal141218 — Fri, 09 Sep 2022 14:06:00 GMT

Hi there,

i want same help.

i want to find diff dates with sum days with SQL Data.

Re: differnce dates with sum

Greg_Deckler — Fri, 09 Sep 2022 14:58:38 GMT

Talal141218 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: differnce dates with sum

tamerj1 — Mon, 12 Sep 2022 07:28:13 GMT

Hi Talal141218
Following to our discussion, please use

Diff Dates = SUMX ( SUMMARIZE ( Fact_PurchOrderLine, Dim_Date[Date_NK], Fact_PurchOrderLine[PurchOrderlineContainer], Fact_PurchOrderLine[PurchOrderlineDateEstimatedDelivery] ), VAR selectdate = Fact_PurchOrderLine[PurchOrderlineDateEstimatedDelivery] VAR currentdate = Dim_Date[Date_NK] RETURN DATEDIFF ( currentdate, selectdate, DAY ) )