Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Date IF Statement

Hi,    I'm trying to do a simple IF Statment but it doesn't seem to work; I'm trying to created a calculate column to use as a customer filter.    I'm looking at 3 Columns as listed below:   (...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Do you check my answers above?

    these are all measures instead of columns

    max selected = MAX('calendar'[Date])

Measure = IF([max selected]>MAX([start])&&[max selected]<=MAX([end]),"Include","exclude")

     

    Best Regards

    Maggie

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi,

try the following measure:

Report Filter = 
IF (
    MIN ( 'dwh InventoryTenancy'[Start] )
        > CALCULATE ( MIN ( 'Date'[Date] ), ALLSELECTED ( 'Date' ) ) &&
    MIN ( 'dwh InventoryTenancy'[End] )
        <= CALCULATE ( MAX ( 'Date'[Date] ), ALLSELECTED ( 'Date' ) ),
    "Include",
    "Exclude"
)

Regards FrankAT

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi FrankAT, 

     

    thanks for your input, I currently getting the insufficent memory error, ( I have 32gb RAM and am connecting to a datawarehouse) so I don't think its really a memory issue.