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 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.
Hi @fahadrq
What do you mean by "Today, I recived data by month"? Please provide sample of the newly recieved data.
aggregated data for one month.
thanks
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |