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...
data protection
Tips and Tricks
  • 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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

nachoroncero , Assuming the date table is governing, then we can get min and max month

 

Meausre =
var _min = eomonth(minx(allselected('Date'), 'Date'[Date]),0)
var _max = eomonth(maxx(allselected('Date'), 'Date'[Date]),0)
return
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) = _max)) - CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) =_min))

 

 

or

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg