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 each time a new day is added by the filter "between".

Example:

 

01.01.2022 - 01.01.2022
Workload = sum(table1[performance]) * 6

*increase the value by 6 as another day is added with the slicer*.


01.01.2022 - 02.01.2022
Workload = sum(table1[performance]) * 12

 

01.01.2022 - 03.01.2022
Workload = sum(table1[performance]) * 18

 

01.01.2022 - 04.01.2022
.

.

.

 

The 6 hours should automatically increase to the 12 hours as soon as one more day is added with the filter "between". If one more day is added the value increases to 18 and on and on...  It would be good if the solution was an equation.

 

I have already tried different possibilities but unfortunately I did not get my result. Hopefully there is someone here who could help me with this problem.

Thank you & greetings
Powerstarter

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 )

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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 )