Forum Discussion

colsand's avatar
colsand
Frequent Visitor
8 years ago
Solved

ANALYSIS TABLE/COUNTX FUNCTION

I am trying to create a small analysis table which gives a breakdown of the number of items which fall within certain lead times.. In excel, this would be a simple matter of using COUNTIF/COUNTIFS bu...
Need Help
Tips and Tricks
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi colsand

 

Could you share your file please?

Or

Provide sample data and desired results

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi colsand

     

    The solution to this is to go other way round

     

    Instead of Pulling data from LT Data into Parameter Table..... Pull the Cluster name from Parameter Table into LT Data

     

    Create a calculated Column in LT Data as follows

     

    Cluster LT =
CALCULATE (
    VALUES ( Parameter_Table[Cluster LT (Days)] ),
    FILTER (
        Parameter_Table,
        'LT Data'[Lead Time] >= Parameter_Table[Start]
            && 'LT Data'[Lead Time] <= Parameter_Table[End]
    )
)

     

      • colsand's avatar
        colsand
        Frequent Visitor
        8 years ago

        Many thanks for your help, that appears to be what I need.

         

        Regards.

         

        Colin