Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

IN/OUT calcule

Hello, I want to calculat the IN and OUT of my stock for 1 week. I have already try that but it's more complicated than we think. For exemple I have this table: Article Name article Week...
Need Help
Imad-R's avatar
Imad-R
Frequent Visitor
3 years ago

Yes, I have a week table.

lbendlin's avatar
lbendlin
Super User
3 years ago

would you mind providing the sample data for it here?

  • Imad-R's avatar
    Imad-R
    Frequent Visitor
    3 years ago

    I want to send the files but I don't know how I can send it ?

      • Imad-R's avatar
        Imad-R
        Frequent Visitor
        3 years ago

        I have add 2 date column in Data table and that is a sample of Date table :

        DateYEAR-WEEK
        01/01/202 00:002023-01
        02/01/2023 00:002023-01
        03/01/2023 00:002023-01
        04/01/2023 00:002023-01
        05/01/2023 00:002023-01
        06/01/2023 00:002023-01
        07/01/2023 00:002023-01
        08/01/2023 00:002023-02
        09/01/2023 00:002023-02
        10/01/2023 00:002023-02
        11/01/2023 00:002023-02
        12/01/2023 00:002023-02
        13/01/2023 00:002023-02

         

        and this is DAX code :

        Date = ADDCOLUMNS(
            CALENDARAUTO(),
            "YEAR-WEEK", YEAR([Date])&"-"&RIGHT("0"& WEEKNUM([Date]),2))
         In addition the link between the table.