Forum Discussion

Powerstarter's avatar
Powerstarter
New Member
3 years ago
Solved

Increase multiplication factor by given value every day

Good evening everybody,   I have a small problem about multiplication in Power BI. I have a given value and I want to multiply it by the factor 6. However, I want the value 6 to increase by ea...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Powerstarter Maybe:

    Workload = 
  VAR __Min = MIN('Table'[Date])
  VAR __Max = MAX('Table'[Date])
RETURN
  sum(table1[performance]) *  ( (__Max - __Min + 1) * 6 )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Powerstarter Maybe:

Workload = 
  VAR __Min = MIN('Table'[Date])
  VAR __Max = MAX('Table'[Date])
RETURN
  sum(table1[performance]) *  ( (__Max - __Min + 1) * 6 )