How to spread resource work on a timescale in Power BI

[GD61]

Hello,

Beginner's question: I created in Excel a report of each resource's work on a day by day time scale.. I was told that it's possible the same report week by week in Power BI.  I tried all day long without success. 

How can I do that?

Thanks

[v-shex-msft]

Hi @GD61,

If you want to calculate value with week, you can add a calculate column which used to calculate the week number, then use dax to calculate the data based on  week number.

Calculate column:

WeekNumber = WEEKNUM([Date created],1)

Measure:

Total = CALCULATE(SUM('Test Sample'[Amount]),FILTER(ALL('Test Sample'),'Test Sample'[WeekNumber]=MAX('Test Sample'[WeekNumber])))

Regards,

Xiaoxin Sheng

[GD61]

Thanks Sheng,

The WeekNumber is well calculated now.

For the Measure, could you explain what are:

'Test Sample'

[Amount]

Thanks a lot

[v-shex-msft]

Hi @GD61,

>>'Test Sample'[Amount]

It means the column which you want to calculated.

Regard,

Xiaoxin Sheng

[GD61]

Thanks Sheng,

I tried WeekNumber = WEEKNUM([TimeByDay],1) but I got the error:

La syntaxe pour '.1' est incorrecte. (DAX(WEEKNUM([TimeByDay].1))).

Translation:

The syntax dor '.1' is not correct. (DAX(WEEKNUM([TimeByDay].1))).

What did I miss?

[v-shex-msft · Accepted solution]

Hi @GD61,

>>The syntax dor '.1' is not correct. (DAX(WEEKNUM([TimeByDay].1))).

The formula is WEEKNUM([TimeByDay],1),  please use "," to spilt two parameters.

Regards,

Xiaoxin Sheng

[GD61]

Definitly, on my French version, the separator is the semi-colom ";"

Thanks a lot