Table format: Either std or Matrix Table

[Anonymous]

Hi Experts

How would you incorporate the QTD1 and QTD2 into a table in power bi....see screen shot image below. i want the same look and feel or something close...

[v-lili6-msft · Accepted solution]

hi,@Route11

    You can use TOTALQTD Function to add a measure like this 

Measure 2 = TOTALQTD(SUM(Table1[Qty]),Table1[Date])

and then drag it into table visual in power bi

Best Regards,

Lin

[Anonymous]

Thanks lin. for the positive feedback