Multipliying Daily values by a factor per "dayofWeek"

[restevez11]

Hi,

I have a measure called "Contratado diario sin Nominaciones" and i need to multiply them by a factor called "Porcentaje" that is stored in another table called "Optimización Contratado" group by day of the week . 

For example, for 04/02/2022, which is a Friday (viernes) the result should be 4505.58 *106% . 

Thanks for your help!

[restevez11 · Accepted solution]

It was easier than expected: I linked the new table with my Dates table. But I will use this option when it's not possible.  Thanks

[v-jingzhang]

Hi @restevez11 

You can try this measure

Measure =
[Contratado diario sin Nominaciones]
    * MAXX (
        FILTER (
            'Optimización Contratado',
            'Optimización Contratado'[Week Day Number] = WEEKDAY ( SELECTEDVALUE ( 'Table'[Date] ), 2 )
        ),
        'Optimización Contratado'[Porcentaje]
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.