hello,
I would like to ask for help.
I calculated accomulated week (Week Sales - see below). This measure I use for grapth.
For total country it works - I see accomulated data (picture 1). But when I using filters by regions it dosent't work - becuase data for 2a or 3 (please see attached file) dosen't exist (picture 2).
Week Sales =
I will be glad for your help.
Hi @Ewa_28 - Slight adjustment of your measure to handle , when filtering by regions where some weeks have no data, causing gaps in your accumulated week sales calculation.
Week Sales =
VAR _select_week = MAX('calendar'[week])
VAR _select_kwartal = MAX('calendar'[q])
VAR _select_year = MAX('calendar'[year])
VAR _cur_week = MAX('Sales'[week])
VAR _cur_kwartal = MAX('Sales'[q])
VAR _cur_year = MAX('Sales'[year])
VAR AllWeeksInFilter =
CALCULATETABLE(
VALUES('calendar'[week]),
ALLSELECTED('Sales')
)
VAR Result =
IF(
_cur_year = _select_year
&& _cur_kwartal = _select_kwartal
&& _cur_week <= _select_week,
CALCULATE(
SUM('Sales'[Sales]),
'Sales'[week] IN AllWeeksInFilter,
'Sales'[q] = _cur_kwartal,
'Sales'[year] = _cur_year
)
)
RETURN
Result
Hope this helps.
Proud to be a Super User! |  |
hi,
I implemented your solution but unfortunatelly it dosen't work 😞
this picture shows data for all regions, it isn't accumulated data
and
filter by one of regions: this data is not accumulated and I lost week where is no data
please help me!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
