cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Need help ith formula

Hi there ;

i need  your  kind support to calculate below issue on my report  ;

i have a table which one's name is Table A as below at left , i would like to calculate day by day increasing of amount based on date and based on Sales Group .Here some users adviced me to use to try "running total"  with quick measure but it s not available for my scenarios  , i need a new table as below at right , could you pls give the formula for new table pls

1 ACCEPTED SOLUTION
Super User

Please try below measure to create a new table.

``````Table 3 =
SUMMARIZE('Table (2)','Table (2)'[reportdate],'Table (2)'[salesgroup],"amount",CALCULATE(sum('Table (2)'[Amount]),FILTER(ALLEXCEPT('Table (2)','Table (2)'[salesgroup]),'Table (2)'[reportdate]<=EARLIER('Table (2)'[reportdate]))))``````

Proud to be a Super User!

4 REPLIES 4
Super User

Please try below measure to create a new table.

``````Table 3 =
SUMMARIZE('Table (2)','Table (2)'[reportdate],'Table (2)'[salesgroup],"amount",CALCULATE(sum('Table (2)'[Amount]),FILTER(ALLEXCEPT('Table (2)','Table (2)'[salesgroup]),'Table (2)'[reportdate]<=EARLIER('Table (2)'[reportdate]))))``````

Proud to be a Super User!

Super User

@erhan_79 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Post Prodigy

Hi  @amitchandak  ;

Infact today i mentioned this issue another ticket , i thought that you were busy , so i reopen again topic

`summarize(Table, Date[Date],table[sales Group],"Amount",CALCULATE(SUM(Table[Amount]),filter(date,date[date] <=maxx(date,date[date]))))`

i tried your below formula  that you gave me today  , i created also a date table too , but something wrong and i can not solve what i tried .

i wanted that everyday system will increase value to previous day based on sales group , but formula calculate just totals for each days

for your easy checking i am sharing my test file

İ have table A ,  below table named "table new " that  i want to create new   , if you should  focus amounts  below  new table  right , first day (15 june ) are 15 June's amounts , but for next days system adding previous day's amount and shows like that , and next day again add all previous day's amounts based on Sales Group  :

i created new table with my test pbix as below , it is not same as you see my above "new table " named

i hope it is clear now :

Super User

I create a measure and used it in display table with date from date table and sales group from table and got the required visual table

``Measure = CALCULATE(SUM('Table A'[Amount]),FILTER(all(Dimdate),Dimdate[Date]<=MAXX('Table A','Table A'[Report Date])))``

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.