Forum Discussion

Gilson_Souza's avatar
Gilson_Souza
Frequent Visitor
4 years ago
Solved

Return value based on hour range

Hi, everyone! I need some help, please. I have two tables that have the listing of events that occurred at certain times. Here's a simplified version of the data file:   Table A: Table B:...
  • SpartaBI's avatar
    4 years ago

    Gilson_Souza create this caclculated column in table A:

     

    ID = 
    VAR _current_cod = 'Table A'[COD]
    VAR _current_date_time_a = 'Table A'[DATETIME]
    VAR _table = 
    FILTER(
        'Table B',
        VAR _current_date_time_b = 'Table B'[DATETIME]
        RETURN
        'Table B'[COD] = _current_cod && ABS(_current_date_time_a - _current_date_time_b ) <= 0.083333333
    )
    VAR _result = CONCATENATEX(_table, 'Table B'[ID])
    RETURN
        _result

     

     


    Showcase Report – Contoso By SpartaBI


         

  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Gilson_Souza write this:

     

    ID =
    VAR _current_cod = 'Table A'[COD]
    VAR _current_date_time_a = 'Table A'[DATETIME]
    VAR _table =
        FILTER (
            'Table B',
            VAR _current_date_time_b = 'Table B'[DATETIME]
            RETURN
                'Table B'[COD] = _current_cod
                    && _current_date_time_a - _current_date_time_b <= 0.0416666667
                    	&& _current_date_time_a - _current_date_time_b >= - 0.125
        )
    VAR _result =
        CONCATENATEX ( _table, 'Table B'[ID] )
    RETURN
        _result

     





          

    Showcase Report – Contoso By SpartaBI