Forum Discussion

Augustas-ase's avatar
Augustas-ase
Icon for Helper II rankHelper II
3 years ago

Formula

how to calculate and get percentages in a column?  
Need Help
BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hello Augustas-ase, So you want the percentage to calculated by each month!!!

Augustas-ase's avatar
Augustas-ase
Icon for Helper II rankHelper II
3 years ago

yes

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    You can do that by
    Modify your formula to
    calculate (

    expression,
    filter(table,table[monthcol] = eariler(table[monthcol]))
    )

    • Augustas-ase's avatar
      Augustas-ase
      Icon for Helper II rankHelper II
      3 years ago

      what should it look like when you put it in this formula?

      Sales =
      VAR _total = sum('Planam'[Sales 2022])
      return
      _total
      • BIswajit_Das's avatar
        BIswajit_Das
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        Sales =
        VAR _total =
        Calculate(

        SUM('Planam'[Sales 2022]),
        Filter('Planam','Planam'[month] = Earlier('Planam'[month]))

        )
        RETURN _total
        try this out