The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there,
Currently working on a formula where I need to count the number of orders based on following criteria: (1) the order saturation is over 100% and (2) the order is between it's delivery date (seperate column) and expiry date (again another seperate column). So far I have the following formula meeting criteria (1) but need to include (2) into the formula, please see below:
Hi @LABrowne please try below, you can tweak it to fit your needs
Active Order Count (Order Saturation > 100%) = COUNTX(VALUES(Order[OrderNumber]),IF([OrderSat] > 1 && DATEDIFF ( [delivery date], [expiry date], DAY )>=0,1))
Hi Walter,
Thanks for your assistance but it is only letting me select measures where as delivery date and expiry date are not measures, I'm not sure why?
Thanks,
Luke
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |