Solved: Format Year

Anonymous · ‎09-02-2021

I 'm trying to use the measure

YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),FILTER('Work Date', 'Work Date'[Calendar Year]=YEAR(TODAY()))).

However, its not working because the "2021" is showing as text. Is there a way to format the measure so the above formula can work. I'm using a live connection so I'm not able to change column.

PaulDBrown · ‎09-02-2021

How about:

YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),FILTER('Work Date', VALUE('Work Date'[Calendar Year])=YEAR(TODAY()))).

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post

PaulDBrown · ‎09-02-2021

How about:

YTD Billable = CALCULATE(SUM(Utilisation[ChargeableHours]),FILTER('Work Date', VALUE('Work Date'[Calendar Year])=YEAR(TODAY()))).

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Format Year

Helpful resources

Power BI Monthly Update - November 2025

Fabric Data Days

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta