Forum Discussion

AutyDA's avatar
AutyDA
Helper I
1 year ago
Solved

Calculate column data for a date based upon a slicer

I am new to PowerBI and slowly learning how to advance.   I have different financial data for various companies and periods. Based upon a series of slicers (company, dates, quarterly/annual data) t...
Need Help
  • zenisekd's avatar
    zenisekd
    1 year ago

    Hi, create these two measures (not columns):

    FirstDateRevenue =
    CALCULATE (
    SUM ( 'Table'[Revenue] ),
    'Table'[Date] = MIN ( 'Table'[Date] )
    )

    LastDateRevenue =
    CALCULATE (
    SUM ( 'Table'[Revenue] ),
    'Table'[Date] = MAX( 'Table'[Date] )
    )

AutyDA's avatar
AutyDA
Helper I
1 year ago

Thank you, that worked perfectly!