Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate Data using Date Slicer

Hi Everyone,   I don't know if this can be done but here goes nothing. I have a Table that has 2 fields; "Report Date" and "Orig Amount". What I would like to do is do create two more columns - one...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

    You can create two measures and place each of them in a Card visual or both in a multi-row Card visual. 

    The measure for Amt Previous:

     

    AmountB4SlicerPeriod =
CALCULATE (
    SUM ( Table1[OriginalAmount] );
    FILTER (
        ALL ( Table1[ReportDate] );
        Table1[ReportDate] < MIN ( Table1[ReportDate] )
    )
)

    and the other one:

     

    AmountDuringSlicerPeriod = 
SUM(Table1[OriginalAmount])

     

    Code formatted with  

     

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

You can create two measures and place each of them in a Card visual or both in a multi-row Card visual. 

The measure for Amt Previous:

 

AmountB4SlicerPeriod =
CALCULATE (
    SUM ( Table1[OriginalAmount] );
    FILTER (
        ALL ( Table1[ReportDate] );
        Table1[ReportDate] < MIN ( Table1[ReportDate] )
    )
)

and the other one:

 

AmountDuringSlicerPeriod = 
SUM(Table1[OriginalAmount])

 

Code formatted with  

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you so much, this works :)