Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

Calculate Range between Dates for each Article

Hi community! I have a transactional table that shows me multiple dates for each article: Article Date A 01.01.2021 A 05.02.2022 A 01.01.2023 B 08.01.2023 ...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi joshua1990 
Please try

=
VAR Dates =
    CALCULATETABLE (
        VALUES ( 'Table'[Date] ),
        ALLEXCEPT ( 'Table', 'Table'[Article] )
    )
VAR StartDate =
    MINX ( Dates, 'Table'[Date] )
VAR EndDate =
    MAXX ( Dates, 'Table'[Date] )
RETURN
    DATEDIFF ( StartDate, EndDate, DAY )