Forum Discussion

heetu24's avatar
heetu24
Helper I
2 years ago
Solved

Need Help in calculated column

Hello All, I want to calculate the BPS(Basis Points) by creating new calculated column  in Power BI Desktop using DAX. Formula = Current Year sales - last Year sales *10000 Sample data  is b...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  heetu24 ,

     

    You might consider using the following dax

    Test =
var _current=
SUMX(
    FILTER(ALL('Table'),'Table'[Period]="Current Year"),[Sales Value])
var _last=
SUMX(
    FILTER(ALL('Table'),'Table'[Period]="Last Year"),[Sales Value])
var _value=
_current - _last * 10000
return
IF(
    'Table'[Product ID]=MINX(ALL('Table'),[Product ID]),_value,BLANK())

     

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  heetu24 ,

 

Here are the steps you can follow：

1. Create calculated column.

 

Test =
var _current=
SUMX(
    FILTER(ALL('Table'),'Table'[Period]="Current Year"),[Sales Value])
var _last=
SUMX(
    FILTER(ALL('Table'),'Table'[Period]="Last Year"),[Sales Value])
return
_current - _last * 10000

 

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly