Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data that when product is sold, it shows within the Retail Period (Year) for that part.
I want to count the number of Retaill Periods, by part.
At the moment Parts either have a status of Active (Y) or Non-Active (N)
How can I express this so it only counts the Active Parts, when I choose a Year?
({$<Year={$(=Only(Year))},(Active)=>}[Retail Period])
Thanks,
Paul
Hi
Try like this
({$<Year={$(=Only(Year))}, Active= , Parts = {'Y'}>}[Retail Period])
Hi,
Try like this
=Count({$<Year={$(=Max(Year))}, Parts = {'Y'}>} distinct [Retail Period])
Regards,
Jagan.
Something like this:
count({$<Year={$(=Only(Year))}, PartStatus={'Active (Y)'}>}[Retail Period])
Replace PartStatus with the name of the field that contains the status values for the parts. Replace 'Active (Y)' with the value that indicates active status.