Forum Discussion

Claythorne's avatar
Claythorne
Frequent Visitor
6 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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())

Claythorne's avatar
Claythorne
Frequent Visitor
6 years ago

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!