Forum Discussion
Need help ith formula
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]))))hope this is helpful.
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
https://drive.google.com/file/d/1Ug3gP3GtYAdgsQui-Fbbp90MzFhlkVNS/view?usp=sharing
İ 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 :
erhan_79 ,
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])))