Forum Discussion

Sportily's avatar
Sportily
Frequent Visitor
4 years ago
Solved

DATEDIFF from Filter

Hi PowerPeople!   Please go easy, I'm a relative newbie, pushing boundaries and learning fast!   I have a working PowerBI instance.  I am looking to add a measure which can present on a card.  ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Sportily 

    If the date slicer is coming from a date table then

    Number of Days =

    COUNTROWS ( 'Date' )

    If date table is not available then create a virtual one and count its rows

    Number of Days =

    COUNTROWS(

    CALENDAR(MIN(Table[Date]), MAX(Table[Date]))

    )

Sportily's avatar
Sportily
Frequent Visitor
4 years ago

Brilliant, thats ace. Thank you so much. Worked a treat. Thanks for being so helpful.