Forum Discussion

slapdragon's avatar
slapdragon
Frequent Visitor
7 years ago

Current date to week difference

Not sure if the title just gives a proper idea of what my query is...   What I am working on is a report of the tasks my team is working on. We track the progress of each task by the date when they...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi slapdragon,

 

According to your description, it seems that you want to define result based on date, right? If so, you could try  to use below measure to see whether it works or not

Measure 9 =
IF (
    MIN ( task[type] ) = "a",
    IF (
        MIN ( task[date] ) <= TODAY ()
            && MIN ( task[date] )
                > TODAY () - 7,
        "last one week",
        IF (
            MIN ( task[date] )
                <= TODAY () - 7
                && MIN ( task[date] )
                    > TODAY () - 14,
            "two week ago",
            IF ( MIN ( task[date] ) <= TODAY () - 14, "no process", "" )
        )
    ),
    ""
)

Best Regards,

Zoe Zhi

 

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

slapdragon's avatar
slapdragon
Frequent Visitor
7 years ago

I am very sorry, but I am very confused about why 'MIN' is used here. If you don't mind, would you be able to explain to me about what this does? I have tried replacing task[date] with the right values, but it didn't seem to work (I know it is my fault.)