KPI for selected date

[Ross1991]

Date             Time Spent

3/5/2024            5

3/15/2024          8

4/17/2024          7

4/24/2024          5

I have one table with above information.  I need to make a KPI where it only need show month of March's Sum.  Anyone can tell me what formula I need?  Thanks in advance.     

[rubenmarin · Accepted solution]

Hi, you can use an expression like: Sum({<Date={"=Month(Date)=3"}>} [Time Spent])

Or create a month field in script: Num(Month(Date)) as MonthNum

And use as Sum({<MonthNum={3}>} [Time Spent])

[Ross1991]

Thank you.  It worked.   I am going to try that formula on Bar Graph as well.