Dax expression

[22LACMT]

Im trying to create a new column that sums the exposure by date.  the date column has 5 unique dates  this column should likewise only show 5 diffent totals.  this is my expression and I am getting errors.  ? 

Totaltier1PIT1 = CALCULATE(sum('Portfolio Percentage totals PIT'[Tier1Exposure]), 'Portfolio Percentage totals PIT'[ver])

sample 

[Samarth_18 · Accepted solution]

Hi @22LACMT ,

You can create a column as below:-

Totaltier1PIT1 =
CALCULATE (
    SUM ( 'Portfolio Percentage totals PIT'[Tier1Exposure] ),
    FILTER (
        'Portfolio Percentage totals PIT',
        'Portfolio Percentage totals PIT'[ver]
            = EARLIER ( 'Portfolio Percentage totals PIT'[ver] )
    )
)

[Samarth_18 · Accepted solution]

Hi @22LACMT ,

You can create a column as below:-

Totaltier1PIT1 =
CALCULATE (
    SUM ( 'Portfolio Percentage totals PIT'[Tier1Exposure] ),
    FILTER (
        'Portfolio Percentage totals PIT',
        'Portfolio Percentage totals PIT'[ver]
            = EARLIER ( 'Portfolio Percentage totals PIT'[ver] )
    )
)

[22LACMT]

If I wanted to group the exposure by a category using a category column and point in time would I use the above and add an additional filter funtion for the category column? 

[Samarth_18 · Accepted solution]

@22LACMT , Yes you can add additional column as filter in the expression.

[22LACMT]

Perfect thank you!