Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

IF statement for date range

Hi there, 

 

Trying to post a list of gifts and have a dynamic card drawing from dates added. The goal is to list a range of dates added if there are more than one distinct value for date added. To do this I am using the First and Last Date functions to create that range and if the distinctcount < 1, return the value in the list. However, I am encountering an error in the if false statement where it is saying that 'date added' column is not found but it is found in the if true statement. I can build a function for listing the range separately but when creating this IF statement, I have not been able to crack the code. Any help would be greatly appreciated. Thanks!

IF(
    DISTINCTCOUNT(PA_DGR_Liam[date_added]) > 1,
    FIRSTDATE(PA_DGR_Liam[date_added]) &" - "& LASTDATE(PA_DGR_Liam[date_added]),
    FORMAT(PA_DGR_Liam[date_added], "MM yyyy")
)

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 

    please try

    =
    IF (
    HASONEVALUE ( PA_DGR_Liam[date_added] ),
    FORMAT ( VALUES ( PA_DGR_Liam[date_added] ), "MM yyyy" ),
    FIRSTDATE ( PA_DGR_Liam[date_added] ) & " - "
    & LASTDATE ( PA_DGR_Liam[date_added] )
    )

  • WinterMist's avatar
    WinterMist
    Impactful Individual

    Anonymous 

     

    What are the chances you could provide a small test data set along with expected results for a given visual?

     

    Regards,

    Nathan