Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everyone,
I have two date fields in my table such as Date 1 & Date 2. But for one Date 2, I want to delete all the dates except the Previous week's date (from the Previous week's Sunday to the Previous week's Saturday). If I add Date 2 to the slicer, it should show dates between the Previous week's Sunday and the Previous week's Saturday. How can I achieve this?
The main requirement is that. I have created this Table.
VAR DateFilter = DATATABLE("Date Filter", STRING,
{
{"Last Week"},
{"Multi Year"}
}
)
RETURN
DateFilter
If the Selection is "Last week" on Slicer then It should use Date 2 in the Date Slicer and If the selection is "Multi Year" then it should use Date 1 in the Date slicer.
How can I achieve this?
Hello @ajitsahoo8338,
Can you please try this approach:
Previous_Week_Filter =
VAR LastSunday =
MAXX(
FILTER(
ALL('YourTable'),
'YourTable'[Date 2] <= TODAY() - WEEKDAY(TODAY(), 1)
),
'YourTable'[Date 2]
) - 6
VAR LastSaturday = LastSunday + 6
RETURN
IF(
SELECTEDVALUE('DateFilter'[Date Filter]) = "Last Week",
IF(
MAX('YourTable'[Date 2]) >= LastSunday &&
MAX('YourTable'[Date 2]) <= LastSaturday,
1, 0
),
1
)
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |