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.
Hello,
I'm new to power BI and I need to show current week and previous week cases (specifically 10/24/2021 - 10/30/21 and 10/17/2021 - 10/23/2021) with a graph in desktop. I tried a couple of different date tables, but I'm unable to figure it out. The count for the current week cases is 10 and the previous week is 15. The file is .csv. The last case number is 21-0104 and last date is 10/26/2021 for table.
@Anonymous
Case Number | Opened |
21-001 | 8/24/2021 |
21-002 | 8/24/2021 |
21-003 | 8/24/2021 |
21-004 | 8/26/2021 |
21-005 | 8/26/2021 |
21-006 | 8/27/2021 |
21-007 | 8/30/2021 |
21-008 | 8/30/2021 |
21-009 | 8/30/2021 |
Solved! Go to Solution.
Hi @Anonymous ,
Your picture can't be displayed...
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
var _todayweek=WEEKNUM(TODAY())
return
IF(
WEEKNUM(MAX('Table'[Opened]))>=_todayweek-1&&WEEKNUM(MAX('Table'[Opened]))<=_todayweek,1,0)
2. Put [Measure] into Filter and set is=1.
3. Result:
The data displayed is the current week and last week
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
Your picture can't be displayed...
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
var _todayweek=WEEKNUM(TODAY())
return
IF(
WEEKNUM(MAX('Table'[Opened]))>=_todayweek-1&&WEEKNUM(MAX('Table'[Opened]))<=_todayweek,1,0)
2. Put [Measure] into Filter and set is=1.
3. Result:
The data displayed is the current week and last week
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous Add a WEEKNUM column and a YEAR column. Then you can do this:
Current Week Cases =
VAR __Year = MAX('Table'[Year])
VAR __Weeknum = MAX('Table'[Weeknum])
RETURN
COUNTROWS(ALL('Table'),[Year]=__Year && [Weeknum]=__Weeknum)
Previous Week Cases =
VAR __Year = MAX('Table'[Year])
VAR __Weeknum = MAX('Table'[Weeknum])
RETURN
COUNTROWS(ALL('Table'),[Year]=__Year && [Weeknum]=__Weeknum-1)
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |