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.
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")
Check out the July 2025 Power BI update to learn about new features.