Forum Discussion
Using date variable in advanced editor returning empty value
Hi all Fairly new to Power BI so hopefully I'm using the right terms etc. I found a similar thread with a different error but it doesn't appear to be resolved: https://community.fabric.microsoft....
danextian
Super User
Super UserHi lgs2024 ,
Did you replace the highlighted string directly with your pq formula or concatenate it with the rest of the strings? For example ...[" & pqformula & "]... pqformula should be replaced by the actual formula.
Apologies for the ignorance, would you be willing to help with an expanded example?
I first tried it like this:
conditions = "doneFlag=false AND dateStart > [Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),0),""yyyy-MM-ddTHH:mm:ss"")]"
I'm not sure how I should be concatenating based on your example. The API formatting requires the date format to be within hard bracket characters [].