Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
Thank you. It worked. I am going to try that formula on Bar Graph as well.