topic Re: Current week to last 6 week Individual week count in DAX Commands and Tips

Current week to last 6 week Individual week count

Anonymous — Thu, 11 Jan 2024 13:04:29 GMT

I have week no column and Termination year column and Tour Request no column and Qt Exclude Flag column in a table in power bi desktop. I have a week column from 1 to 52 week numbers. I want to show the distinct count of Tour Request no of Every week of Termination Year Current year and Qt Exclude Flag '0' individually up to current week in the line chart .and the Current week to Past 6 weeks count should be Dynamically change weekly when I refresh the report

Like this. for example my currentweek is 48, the linechart should show the current week and Last 6 weeks Data for individual weeks.

Re: Current week to last 6 week Individual week count

Jihwan_Kim — Fri, 12 Jan 2024 04:29:14 GMT

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file, and try using WINDOW DAX function.

WINDOW function (DAX) - DAX | Microsoft Learn

Quantity last 6 weeks: = VAR _t = FILTER ( ALL ( 'Calendar'[WeekStartDate], 'Calendar'[Year-Week] ), [Quantity:] <> BLANK () ) RETURN CALCULATE ( [Quantity:], KEEPFILTERS ( WINDOW ( 1, ABS, 6, ABS, _t, ORDERBY ( 'Calendar'[WeekStartDate], DESC ) ) ) )

Re: Current week to last 6 week Individual week count

Anonymous — Mon, 15 Jan 2024 06:21:52 GMT

My Data Model is look like this..

I want To show Only Current Week to Past 5 weeks Count data in this visual and dynamically the current week number should be change weekly when dataset is refreshed