Can we calculate in PBI like we do in Excel ?

[Saab95]

Hi there,

I'm new to power bi and so far we have always been working with excel. But as want to have a dashboard for the data it's time for change.

The question is :
Is it possible to calculate in PBI like we do in excel ?

i.e let's do a basic excel formula =G2-(F2*0.15) can you achieve the same in PBI ?
Would it be like =CALCULATE(Data[Field1]-(Data[Field2]*0.15))

Thank you

 

[GraH]

It could be a calculated column, where you simply use the table syntax

 [ column y] -( [ column x] * 0.15 )

If you want a measure you need to use an interating function like sumx, or any other aggregateX function inside calculate.