Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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.
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.
thanks that worked. If I want to see total YTD would it be:
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |