topic Re: Filtering in Desktop

Filtering

Anonymous — Thu, 12 Oct 2017 16:45:22 GMT

I have a model with 3 columns Buy/Sell (which a text column), Amount (Integer) and Date (Date). I need to be able to subtract sells from buys over a variety of time periods. I can't work out if this should be done as a new calculated column or measure.

Re: Filtering

vcastello — Thu, 12 Oct 2017 20:16:03 GMT

Hi Anonymous

A measure should work.

I assume all the sell records have a minus sign so ...

Measure1 = SUM(TableName[Amount])

should work

If you create a visual and place the date in one axis or column or whatever visual you choose and in the values of that visual you place Measure1 should work with no problems.

Hope that helps

Vicente

Re: Filtering

Ashish_Mathur — Fri, 13 Oct 2017 00:07:11 GMT

Hi Anonymous,

What result are you expecting?

Re: Filtering

v-huizhn-msft — Fri, 13 Oct 2017 08:38:11 GMT

Hi Anonymous,

Please post your expected result based on the sample table, so that we can share the workaround which is close to your requirement.

Best Regards,
Angelia

Re: Filtering

Anonymous — Fri, 13 Oct 2017 10:47:15 GMT

I am trying to filter all buys with dates into a measure and all sells into a measure so that I can subtract sells from buys over anytime period.

Re: Filtering

Ashish_Mathur — Fri, 13 Oct 2017 11:03:34 GMT

Hi,

Try this

=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Buy")

and

=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Sell")

Hope this helps.