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

[Anonymous]

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

[v-danhe-msft · Accepted solution]

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