Return columns when the to and from dates fall between the current date

[RavChop]

Hi, I'm quite the PowerBI amateur but I was trying to create a measure that does the following. 

I want to display the current weeks reporting week when the effective from date is greater than or equal to todays date, and the effective to date is less than or equal to todays date. 

I have created the following measure 

Current Reporting Week = 
IF (
    VALUES ( recco_mscreportingweek[recco_effectivefrom] ) >= TODAY ()
        && VALUES ( recco_mscreportingweek[recco_effectiveto] ) <= TODAY (),
    true,
    false
)

But what I want to do is return the reporting week column if the statement above is true. 

A measure may not be the way to go, so any help at all will be appreciated. 

Thank you. 

[amitchandak · Accepted solution]

@RavChop , you can have a column like

Current Reporting Week =
IF (
( recco_mscreportingweek[recco_effectivefrom] ) >= TODAY ()
&& ( recco_mscreportingweek[recco_effectiveto] ) <= TODAY (),
recco_mscreportingweek[reporting week],
blank()
)

or create a measure

Current Reporting Week =
countrows(Filter(recco_mscreportingweek, IF (
VALUES ( recco_mscreportingweek[recco_effectivefrom] ) >= TODAY ()
&& VALUES ( recco_mscreportingweek[recco_effectiveto] ) <= TODAY (),
true(),
false()
)))

use with reporting week

[RavChop]

I tried creating a column, however, when I try to use that column in a visual there seems to be no data. I have checked to ensure I have date that falls between the date range of effective from and effective to, but the visual is still blank. 

[RavChop]

Apologies, I realise my condition was wrong and needed to swap around the >=, this has worked really well, thank you!