Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Display elements from a selected date (between start and end date)

Hi PowerBI Community,   I don't find a way to display information according to a selected date. Here is my problem:   I have a set of data that looks like this:   I would like to sum up t...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Measure =
VAR _table =
    ADDCOLUMNS (
        'Year',
        "Value",
            SUMX (FILTER ('Table',
                    [Start date] <= EARLIER ( 'Year'[Year] )
                        && [End date] >= EARLIER ( 'Year'[Year] ) ),
                [Estimated volume] ) )
RETURN
    SUMX ( _table, [Value] )

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.

Measure =
VAR _table =
    ADDCOLUMNS (
        'Year',
        "Value",
            SUMX (FILTER ('Table',
                    [Start date] <= EARLIER ( 'Year'[Year] )
                        && [End date] >= EARLIER ( 'Year'[Year] ) ),
                [Estimated volume] ) )
RETURN
    SUMX ( _table, [Value] )

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.