Forum Discussion

FEninja_'s avatar
FEninja_
Helper I
3 years ago

FILTER - Variable Date Not Working, But Fixed Date Value works.

PBIX FILE => https://www.dropbox.com/s/ajtw8674sjk1vxc/FE-AgileMetrics_MVP3-TEST.pbix?dl=0 EXACTLY WHAT I AM TRYING TO ACCOMPLISH: (Forecast Lines)   ======== Hello Productive People!   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi FEninja_ ,

 

Please try this measure:

Measure = 
VAR projDate = [Release BD - Projected Completion Date (1)] 
RETURN
if( 
    ISBLANK(
        COUNTROWS(
            Filter(
                ALL('DATE'),
                'DATE'[Date] >= TODAY() && 'DATE'[Date] <=  projDate
            )
        )
    ),BLANK(),lastval 
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

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

FEninja_'s avatar
FEninja_
Helper I
3 years ago

Thank you for your response! I updated my original post to include a sample PBIX file along with more clarity about what I hope to accomplish. Thanks for your help