Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I am looking for some help on how to ignore a month when I add it to my table.
The intent of this table is to show if the customer did not order during baseline dates (example 8/1/22 thru 7/31/23), but has now ordered more than a qty of 2 after baseline dates then count sales. If they did order during baseline dates, then do not count sales.
Here are my dax formulas:
New Distribution Qty
New Distribution Qty =
IF([Total Qty Baseline]=0 && [Total Qty New Distribution] > 2,
[Total Qty New Distribution],0)
Gaps Closed:
Gaps Closed =
SUMX(SUMMARIZE('VALUE ENTRY', CUSTOMER[Territory Code],CUSTOMER[Customer Code],'ITEM'[Item No]), IF([Total Qty Baseline] =0 && [Total Qty New Distribution] > 2 , 1 ,0)+0)
Here is what the correct table would show:
But then when I go to add in the month column - the current dax formula will include each month of orders if baseline quantity was 0. I am looking for the formula to count only the first sale order and ignore all of the future orders.
Here is what the table shows:
I will know the formula is working when Customer A shows only the sales order in August.
September and October's sales orders would not count.
Really hoping someone can help me here 😊
Thanks so much,
Christina
Hi @christina_chapm example is below on link
Proud to be a Super User!
Hi @some_bih ,
The link only shows how to identify the minimum in the context of sales amount. I'm looking for the first order date sales amount with ignoring month context which unfortunately it does not show.
Best,
Christina
Hi @christina_chapm please share example file, with expected output
Proud to be a Super User!
Hi @christina_chapm idea: if you have already measure try to use MINX per customer ID for that measure
For "dates" think about Calendar par Year-Month, not just month as you could be missleaded only using month (or you realy want it)
Proud to be a Super User!
Hi @some_bih ,
Thanks for the response!
Can you give me an example of how I would integrate MINX with customer ID into the formula?
Thanks again,
Christina
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |