Forum Discussion
Updating Production Target
Hello!
Sorry if this seems like a silly question, but I'm just starting out in Power BI and can't seem to find a way to do this simple task. I have a data set with daily production targets and I would like to make a KPI that displays the target based on todays values. I've imported the data but I'm not really sure how to go about from there.
If anyone could lead me in the right direction I'd love to learn more!
I do not think I got it completely
Todays Target = calculate(sum(Table[Target]),table[Date]=Today())
better do it with date table. joined with your table
Todays Target = calculate(sum(Table[Target]),Date[Date]=Today())
2 Replies
I do not think I got it completely
Todays Target = calculate(sum(Table[Target]),table[Date]=Today())
better do it with date table. joined with your table
Todays Target = calculate(sum(Table[Target]),Date[Date]=Today())So I did
HCN Target Consumption = CALCULATE(sum(Sheet2[HCN]),Sheet2[Date]=Today())and that seemed to do the trick!By any chance, do you know how I could reformat the numbers so that they are whole numbers (i.e. 134194 instead of 134.19k)Edit: Nvm I found it under the Format column > Data label > Display units > None. Thanks again for the help!
