Forum Discussion

m_roussakis's avatar
m_roussakis
Icon for Helper III rankHelper III
3 years ago
Solved

How to Calculate total rows for previous year

I've been googling this for an hour...have tried many things, nothing works.    How would I calculate the total # rows for the previous year. Here's the latest attempt to fail:   Total Previous ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi m_roussakis ,

    I have created a simple sample,please refer to it to see if it helps you.'

    Create a measure.

    Measure = var _1=YEAR(TODAY())-1
return
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),YEAR('Table'[date])=_1))

    Or a column.

    Column = var _1=YEAR(TODAY())-1
return
CALCULATE(COUNTROWS('Table'),FILTER(('Table'),YEAR('Table'[date])=_1))

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    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
3 years ago

Hi m_roussakis ,

I have created a simple sample,please refer to it to see if it helps you.'

Create a measure.

Measure = var _1=YEAR(TODAY())-1
return
CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),YEAR('Table'[date])=_1))

Or a column.

Column = var _1=YEAR(TODAY())-1
return
CALCULATE(COUNTROWS('Table'),FILTER(('Table'),YEAR('Table'[date])=_1))

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

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

m_roussakis's avatar
m_roussakis
Icon for Helper III rankHelper III
3 years ago

thanks that worked. If I want to see total YTD would it be:

 

Previous Year Total = var _1=YEAR(TODAY())
return
CALCULATE(COUNTROWS('Extra Pulls'),FILTER(all('Extra Pulls'),YEAR('Extra Pulls'[ACTL_EVT_DT])=_1))