Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date Parts Produced
Feb 50
Feb 100
March 100
March 200
I have a table just like above. Can someone please tell me what formula I need to put on KPI measure field to just get month of Feb? It should display 150. The formula I had used previously did not work in this table, but previously my table had 3/3/24 date format. I had used Sum({<Date={"=Month(Date)=3"}>}[Parts Produced])
This formula did not work for above table. Please help! Thank you.
Sum({<Date={Feb}>}[Parts Produced])
Sum({<Date={Feb}>}[Parts Produced])
Thanks. It worked.