cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD61 Member
Member

How to spread resource work on a timescale in Power BI

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. Smiley Sad

How can I do that?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: How to spread resource work on a timescale in Power BI

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
6 REPLIES 6
Community Support Team
Community Support Team

Re: How to spread resource work on a timescale in Power BI

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
GD61 Member
Member

Re: How to spread resource work on a timescale in Power BI

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?

 

Highlighted
Community Support Team
Community Support Team

Re: How to spread resource work on a timescale in Power BI

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
GD61 Member
Member

Re: How to spread resource work on a timescale in Power BI

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

Thanks a lot

GD61 Member
Member

Re: How to spread resource work on a timescale in Power BI

Thanks Sheng,

 

The WeekNumber is well calculated now.

 

For the Measure, could you explain what are:

'Test Sample'

[Amount]

 

Thanks a lot

Community Support Team
Community Support Team

Re: How to spread resource work on a timescale in Power BI

Hi @GD61,

 

>>'Test Sample'[Amount]

It means the column which you want to calculated.

 

Regard,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,777 guests
Please welcome our newest community members: