Forum Discussion

vytas's avatar
vytas
Icon for Helper I rankHelper I
6 years ago
Solved

Min/Max Dates

Hi,  I have virtual table : Unpaid Invoices = FILTER (     ADDCOLUMNS (         SUMMARIZE (             Debt;             Debt[DocumentNr];             Debt[CompanyNo];             Debt[Paym...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi vytas 

     

    Try something like this.

    Measure = 
VAR __tbl =
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE (
                Debt;
                Debt[DocumentNr];
                Debt[CompanyNo];
                Debt[PaymentDay]
            );
            "Saldo"; CALCULATE ( SUM ( Debt[Debt] ) );
            "InvoiceDate"; CALCULATE ( MAX ( Debt[InvoiceDate] ) )
        );
        [Saldo] > 0
    )
VAR __min = MINX( __tbl, [InvoiceDate] )
VAR __max = MAXX( __tbl, [InvoiceDate] )
RETURN 
    __max - __min

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi vytas 

 

Try something like this.

Measure = 
VAR __tbl =
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE (
                Debt;
                Debt[DocumentNr];
                Debt[CompanyNo];
                Debt[PaymentDay]
            );
            "Saldo"; CALCULATE ( SUM ( Debt[Debt] ) );
            "InvoiceDate"; CALCULATE ( MAX ( Debt[InvoiceDate] ) )
        );
        [Saldo] > 0
    )
VAR __min = MINX( __tbl, [InvoiceDate] )
VAR __max = MAXX( __tbl, [InvoiceDate] )
RETURN 
    __max - __min

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • vytas's avatar
    vytas
    Icon for Helper I rankHelper I
    6 years ago

     

    That's what i needed. Strugled to reach date in virtual table. 

    Just wrapped RETURN in datediff.

     

    Thank You.