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

Anonymous
Not applicable

## Generating Sum of Backend Data (Qty and Amount) on Daily basis ( Separate Value Everyday)

Hello All,

I am creating a chart using some data.

I have directly connected the data source to power bi. this will be refreshed on daily basis. This database has some columns like below-

productcode    qty        value

aaa                  5000      \$100

bbb                  6000      \$400

and so on..

I want to sum the total of qty and value on daily basis like

Date                   total qty                                                     total value

12 apr 19            11,000                                                           \$500

13 apr 19            (11,00+new added rows after refresh on next day)     (500+new added rows after refresh on next day)

I dont have any DATE Reference to do same.

How to do this in Dax?? Need Help

1 ACCEPTED SOLUTION
Microsoft Employee

Hi @Anonymous ,

I suggest you to add a data column for your based dataset like below:

Create below measures:

`Total qty = CALCULATE(SUM(Table1[qty]),FILTER(ALL(Table1),'Table1'[Date]<=MAX('Table1'[Date])))`
`Total value = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),'Table1'[Date]<=MAX('Table1'[Date])))`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft Employee

Hi @Anonymous ,

I suggest you to add a data column for your based dataset like below:

Create below measures:

`Total qty = CALCULATE(SUM(Table1[qty]),FILTER(ALL(Table1),'Table1'[Date]<=MAX('Table1'[Date])))`
`Total value = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),'Table1'[Date]<=MAX('Table1'[Date])))`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.