Forum Discussion

JLMLV00's avatar
JLMLV00
Frequent Visitor
3 years ago

Measure instead of calculated columns

Hi,  I want to calculate de difference between invoiced amount (€) and a recalculated amount. I get it done with calculated columns in my FactInvoices table but instead i would rather use a measure ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

JLMLV00 , You have force that calculation at row level in meausre

 

Example

Sumx(Table,

var _col = <Column calc>

return <More calc> )

 

or

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

JLMLV00's avatar
JLMLV00
Frequent Visitor
3 years ago

Thanks a lot, 
hope you can help me out with this one, 
Client A has more than one rows in the recalculationtable 
from 1-1-23 till 30-6-23 their recalculated pricing method is 2 
from 1-7-23 till 31-12-23 pricing method is 3 
with Sumx <=max(date) etc.  the invoicerows from 1-1-23 till 30-6-23 wont show their recalculation pricing, because he's gonna use the max dates of the clients, when used MIN() the invoice rows after 30-6-23 wont show up. 
SUMX(Filter(Invoicetable,Invoicetable[date]>=Max(Recalculationtable[startdate]&&Invoicetable[date]<=Max(Recalculationtable[Enddate]), [Listprice])