Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

True/False Values

Hi Team,   Need some help on this, I have Date A and Date B and I need to use a filter like this-: YEAR([ Date A]) >= 2018 && [Date A] <= [Date B]  , I am also using Date B as filter to filter val...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak  Pragati11  dax 

 

   Column          Type                     Ranges 

  Planned Date   Date                 from 01/01/2015 till 01/05/2020

  Request Date   Date                  from 01/01/2015 till 01/05/2020  

Amount             whole number   as per source

 

** I use date filter from Planned date to choose date range. 

 

now my requirement is to create a filter based on the request date and Planned date. the formula is 

 

YEAR([Request Date]) >= 2018 AND [Request Date] <= [Planned Date] 

 

this gives correct value on Tableau but gives wrong value on power BI.

 

 

 

Thanks.