Dax

fahadrq — Sun, 04 Dec 2022 14:04:45 GMT

Hi everybody.

I recived weekly data in excel, all data have a column (date) and comes for the day that i recived data in (Thursday). So I created dashboard contains all weekly data and I can compare with previous week. for the comparison I used these formulas (

weekNum = WEEKNUM('Date'[Date])

WeekEndDate = 'Date'[Date]+7-1*WEEKDAY('Date'Date],1)

WeekStartDate = 'Data'[Data]+-1*WEEKDAY('Date'[Date],1)+5

WeekRang = RANKX(ALL('Date'),'Date'[WeekStartDate],,ASC,Dense)).

Also, I have filter represents all dates so I can select any date and compare it with previous week.

Today, I recived data by month and I want adjust my formula to work with both.

*Note: I can not sum weeks to get data for months.

Thanks.

Re: Dax

tamerj1 — Sun, 04 Dec 2022 18:33:56 GMT

Hi fahadrq
What do you mean by "Today, I recived data by month"? Please provide sample of the newly recieved data.

Re: Dax

fahadrq — Mon, 05 Dec 2022 20:32:34 GMT

aggregated data for one month.

thanks

topic Re: Dax in DAX Commands and Tips

Dax

Re: Dax

Re: Dax