Forum Discussion

horsebaker's avatar
horsebaker
Regular Visitor
2 years ago
Solved

Removing Sales position using different date

Dear community! The problem I am encountering: I have Sales data with Item positions. It is considered Orders received with "Document Date" attached to this position. However, I also have anothe...
  • ahadkarimi's avatar
    ahadkarimi
    2 years ago

    If you have any questions or need more info, just hit me up!

    Original Orders =
    CALCULATE(
    SUM(Sales[ItemCount]),
    Sales[Status] <> "Rejected")
    ----------------------------------
    Rejected Items =
    CALCULATE(
    SUM(Sales[ItemCount]),
    Sales[Status] = "Rejected")
    -----------------------------
    Adjusted Orders =
    CALCULATE(
    [Original Orders] - [Rejected Items],
    DATESBETWEEN(
    'Calendar'[Date],
    MIN('Calendar'[Date]),
    MAX('Calendar'[Date])))

ahadkarimi's avatar
ahadkarimi
Solution Specialist
2 years ago

If you have any questions or need more info, just hit me up!

Original Orders =
CALCULATE(
SUM(Sales[ItemCount]),
Sales[Status] <> "Rejected")
----------------------------------
Rejected Items =
CALCULATE(
SUM(Sales[ItemCount]),
Sales[Status] = "Rejected")
-----------------------------
Adjusted Orders =
CALCULATE(
[Original Orders] - [Rejected Items],
DATESBETWEEN(
'Calendar'[Date],
MIN('Calendar'[Date]),
MAX('Calendar'[Date])))