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 all,
I am trying to do something similar with the below Alteryx expression. In the API URL, I want to include the date parameter. So if powerbi refreshes on Monday, it will lookback 3 days before which is friday. Else it will just lookback yesterday's date. My PowerBI advanced editor only can look back to yesterday's date. How can I extend to include the IF THEN ELSE statement?
Alteryx:
IF DateTimeFormat(DateTimeToday(),"%A") = "Monday"
THEN [FX URL] + DateTimeFormat(DateTimeAdd(DateTimeToday(),-3,"days"),"%Y%m%d")
ELSE [FX URL]+DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"days"),"%Y%m%d")
ENDIF
PowerBI:
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-1), "yyyyMMdd")
Solved! Go to Solution.
if Date.DayOfWeek(DateTime.FixedLocalNow())=1
then
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-3), "yyyyMMdd")
else
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-1), "yyyyMMdd")
if Date.DayOfWeek(DateTime.FixedLocalNow())=1
then
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-3), "yyyyMMdd")
else
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-1), "yyyyMMdd")
Didn't realize it is that straightforward as I thought IF THEN ELSE is not accepted in advanced editor. The only thing I added below in red to recognize Monday is 1.
if Date.DayOfWeek(DateTime.FixedLocalNow(), Day.Sunday)=1
then
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-3), "yyyyMMdd")
else
DateTime.ToText(Date.AddDays(DateTime.FixedLocalNow(),-1), "yyyyMMdd")
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |