Forum Discussion

nachoroncero's avatar
nachoroncero
Frequent Visitor
4 years ago
Solved

New in Power BI - Using two date filters

Hello,   Sorry if y question is too newbie, it is my first time using this tool.   I am trying to show the results of a company in a specific month, but also in during a period of time. In the g...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi nachoroncero , 

    Please refer to my pbix file to see if it helps you.

    Create a measure.

     

    Measure =
    VAR _start =
        DATE ( 2017, 1, 1 )
    VAR _value =
        CALCULATE (
            SUM ( 'Table'[value] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[date] >= _start
                    && 'Table'[date] <= SELECTEDVALUE ( 'Table 2'[Date] )
            )
        )
    RETURN
        _value
    

     

     

    Cancel the work of the slicer on the guage, select Format>>Edit interaction.  

    Then choose none.

    Then filter the data on this visual.

     

     

     

     

    If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

     

    Best Regards

    Community Support Team _ Polly

     

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