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 everyone,
I really got stuck with this one. I can't find any help for the PREVIOUSDAY function. I need to add a column with the previous date's value for a certain value in another column. My dates are not continuous. Example:
Segment Date UniqueOpenRate
WiFi 1/3/2020 15%
Hotel concierge 1/3/2020 14%
WiFi 2/3/2020 16%
Hotel Concierge 2/3/2020 13%
I need to be able to add a new column where I set the previous value for each Segment:
Segment Date PrevOpenRate
WiFi 2/3/2020 15%
How can I do that?
Thanks!
Stan
Solved! Go to Solution.
This works! Thank you so much! Yuu saved me so much time!
Hi @Anonymous
try Measure
Measure =
var _curDate = MAX('Table'[Date])
var _prevDate = CALCULATE(MAX('Table'[Date]), ALLEXCEPT('Table','Table'[Segment]),'Table'[Date] < _curDate)
RETURN
CALCULATE(SUM('Table'[UniqueOpenRate]), FILTER(ALLEXCEPT('Table','Table'[Segment]),'Table'[Date] = _prevDate))
This works! Thank you so much! Yuu saved me so much time!
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |