Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi,
Try this
=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Buy")
and
=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Sell")
Hope this helps.
Hi @Absalon29,
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
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.
Hi,
Try this
=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Buy")
and
=CALCULATE(SUM(Data[Amount]),Data[Buy/Sell]="Sell")
Hope this helps.
Hi @Absalon29,
What result are you expecting?
Hi @Absalon29
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |