Forum Discussion

gpiero's avatar
gpiero
Skilled Sharer
9 years ago
Solved

creating a summury table from existing PBD table

I have created a report that summarize values for each storage location using data come from ERP every week. Thanks to previous advices I have got in this forum it works properly.   But now the Co...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi gpiero,

     

    Based on your description, you want to get the weekly summary of your records, right?

    You can refer to below formula to get weekly summary data(weeknum function):

     

    Base table:
     

     

    Measures:

    WeekNumber = WEEKNUM(MAX('Table'[Date]))

     

    Weekly Summary =
    var currDate=MAX('Table'[Date])
    var CurrWeekNo=WEEKNUM(MAX('Table'[Date]))
    return
    SUMX(FILTER(ALL('Table'),AND(WEEKNUM('Table'[Date])=CurrWeekNo,YEAR([Date])=YEAR(currDate))),'Table'[Amount])

     

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

gpiero

 

Could you be a little more specific in what is the output exxpected and some sample data to work out a solution.

 

Cheers

CheenuSing

  • gpiero's avatar
    gpiero
    Skilled Sharer
    9 years ago

    @CheenuSing

     

    my goal would be fill tha table Dashboard Stock Values (1st pct) automatically each time (weekly) the table MB52 will be refreshed by data extracted from ERP each week.

     

    The measures existing in the table MB52.... contanins the value to transfer in the Dashboard.

    Then I will add a row each week and every chart, report or analisys wil be based on the Dashbord Stock Values.

     

    Thanks

     

    gpiero