Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Need Help
Tips and Tricks
hamidreza01's avatar
hamidreza01
New Member
3 years ago

Hello
I have used the following commands to call a data table in Power BI, but I have encountered problems, please help. Thank you for your cooperation
I just have to say that I want to use the current date in every run
= Sql.Database("MESODB", "CWLDATA", [Query="#(lf)select acccode,accname,SUM(ISNULL(DebitAmount,0)-ISNULL(CreditAmount,0)) Balance from Vmoein#(lf)where mesocomp = 'AZHD' and mesoyear = 1466 and (CAST(DateEn AS DATE) <= '"&DateTime.Date(DateTime.LocalNow())& "' OR period IS NULL or period = 0)#(lf)group by acccode ,accname#(lf)"])

Expression.Error: We cannot apply operator & to types Text and Date.
Details:
Operator=&
Left=
select acccode,accname,SUM(ISNULL(DebitAmount,0)-ISNULL(CreditAmount,0)) Balance from Vmoein
where mesocomp = 'AZHD' and mesoyear = 1466 and (CAST(DateEn AS DATE) <= '
Right=10/2/2022