Forum Discussion

dpotta's avatar
dpotta
Icon for Resolver I rankResolver I
5 years ago
Solved

Help with GENERATE SERIES/FILTER/CALCULATE

Hi   I am new to this and struggling with how to use GENERATE SERIES to filter a table.   I have a numeric column in a table named tblSelection[Age of Company].   I have used GENERATESERIES to ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    dpotta , if you are creating a slicer using this new table and try to filter , then you have to create it as a measure as column will not take the slicer value.

     

    What are you trying to achieve here.

dpotta's avatar
dpotta
Icon for Resolver I rankResolver I
5 years ago

Hi Amit

 

I can see you are very knowledgeable and I am not.

 

All I am trying to do is filter a table where the values in the column tblMatches[Age of Company] fall between two values:

 

the first is the tblSelection[AGE OF COMPANY])*0.9
 
and the second the (tblSelection[AGE OF COMPANY])*1.1)
 
Obviously you know when to use GENERATESERIES and I do not.
 
How do I filter the tblMatches with these criteria?
 
Many thanks