Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Thanks Sheng,
The WeekNumber is well calculated now.
For the Measure, could you explain what are:
'Test Sample'
[Amount]
Thanks a lot
Hi @GD61,
>>'Test Sample'[Amount]
It means the column which you want to calculated.
Regard,
Xiaoxin Sheng
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?
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
Definitly, on my French version, the separator is the semi-colom ";"
Thanks a lot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |