Forum Discussion
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...
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]
)
)
Many thanks for your help, that appears to be what I need.
Regards.
Colin
Hi colsand
I noticed that some of your Lead Times fall in none of the Clusters. For example Leadtime greater than 200
You can always go back and revise the Start and End ranges of your Parameter Table or Add new cluster
Yes, thank you, I will set the end point way over the maximum to allow for this.
Regards.
Colin
