Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi, I have a problem obtaining the correct value: I need to obtain the sales sum from the SPR[NETTO] column for the assortment KOLORYZACJA from the table ASORT[poizion2] = "KOLORYZACJA". The sales sum should only include the first month in which the sales for this assortment reached a minimum of 450 for a specific customer[id]. Thank you for your help.
Solved! Go to Solution.
Hi,
If I understand the question correctly, you probably need a formula like this in DAX:
SalesSum :=
CALCULATE(
SUM(ASORT[SPR[NETTO]]),
ASORT[ASORT[poizion2]] = "KOLORYZACJA",
ASORT[Sales] >= 450,
FIRSTDATE(ASORT[Month])
)
Hi,
If I understand the question correctly, you probably need a formula like this in DAX:
SalesSum :=
CALCULATE(
SUM(ASORT[SPR[NETTO]]),
ASORT[ASORT[poizion2]] = "KOLORYZACJA",
ASORT[Sales] >= 450,
FIRSTDATE(ASORT[Month])
)
Check out the November 2023 Power BI update to learn about new features.