Forum Discussion

Talal141218's avatar
Talal141218
Icon for Helper III rankHelper III
4 years ago
Solved

differnce dates with sum

Hi there,  i want same help.  i want to find diff dates with sum days with SQL Data. 
  • tamerj1's avatar
    tamerj1
    4 years ago

    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 )
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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.