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.
Hi, this maybe really simple to answer but as im new to this and have not found the answer online after a few hours and countless videos online please help.
I have a custom calender and would like to get the totals of each week number. As this will be over a few years i would like to get the wekly totals from Years & Week. I think i need to create a new column with week totals in? It sfor week on week comparisons but i cant figure out the weekly totals to get that far yet. Thanks for your help in advance.
Solved! Go to Solution.
HI @Anonymous ,
I'd like to suggest you use year and week number as filter conditions to aggregate values.
Measure =
VAR currDate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Daily Total] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( [Date] ) = YEAR ( currDate )
&& WEEKNUM ( [Date], 2 ) = WEEKNUM ( currDate, 2 )
)
)
Regards,
Xiaoxin Sheng
HI @Anonymous ,
I'd like to suggest you use year and week number as filter conditions to aggregate values.
Measure =
VAR currDate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Daily Total] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( [Date] ) = YEAR ( currDate )
&& WEEKNUM ( [Date], 2 ) = WEEKNUM ( currDate, 2 )
)
)
Regards,
Xiaoxin Sheng
Thanks for your help that worked
@Anonymous
Try this:
create measure for daily totals = SUM(dCalender[Daily Total])
and then create new measure along the lines of:
year and week totals = CALCULATE([daily totals], ALLEXCEPT(dCalender[Year & Week]))
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |