Solved: Re: Table format: Either std or Matrix Table

Anonymous · ‎09-19-2018

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 · ‎09-19-2018

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

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

View solution in original post

v-lili6-msft · ‎09-19-2018

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

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