Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
I need to produce a Card with a measure that will count a dated column, it should produce a count if it is within this year. so the below table has 7. I can get it to work with a helper column as shown in right but I would prefer to have a measure rather than a calculated column. Is this possible?
I tried:
Solved! Go to Solution.
Hi @JVP
A small correction
This Year = CALCULATE(COUNTROWS('Table'),YEAR('Table'[Date])=YEAR(TODAY()))
Hi @JVP
A small correction
This Year = CALCULATE(COUNTROWS('Table'),YEAR('Table'[Date])=YEAR(TODAY()))
Thanks very much! That worked. I guess I wa almost there...😁
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
108 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |