Forum Discussion
Solved
Billing items
Hi, I really don't know how to solve this problem: I have a table with costumers orders and there's not a flag that tell me how many items are delivered. I only know that (in this example), for orde...
Hi, Supermat
Create a measure that compares the delivery date to today, and if it is greater than today, it is active.
_ac = IF ( MAX ( 'Table'[SBDAT] ) > TODAY (), 1, 0 )Create a measure to count the active status.
_Activate_count = CALCULATE ( COUNT ( 'Table'[SBDAT] ), FILTER ( 'Table', 'Table'[_ac] = 1 ) )Another measure can be created to apply conditional formatting to the field so that the active date is highlighted.
_color = IF([_ac]=1,"pink")result:
Please refer to the attachment below for details. Hope this helps.
If I don't understand you correctly, please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
