cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jolyon Member
Member

Re: Date Transformations in Direct Query mode?

thank you,Lidya!

I will check it!

Jolyon Member
Member

Re: Date Transformations in Direct Query mode?

Hallo @v-yuezhe-msft

could you please send the attached pbix.file from your message to my Email jolyonforsyte@yandex.com?

For I didn't manage to register myself in OneDrive.

 

And I have one more question:

when I take formula

show = IF('Date'[MonthSequentialNumber]>=[CurrentMonthSeqeuntialNumber]&& 'Date'[MonthSequentialNumber]<=[CurrentMonthSeqeuntialNumber]+5,1,0)

should I place a comma between  5 and 1 and 0 or semicolon?

 

In my Power BI Desktop I have always this issue with semicolons - if I take a comma, it is marked as a mistake in the formula.

P.s.I have the newest Updateof Power BI

 

thanks a lot!

Moderator v-yuezhe-msft
Moderator

Re: Date Transformations in Direct Query mode?

Hi @Jolyon,

I have sent the PBIX file to you via Email. Please check the formulas in the PBIX file.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FrankWeng Visitor
Visitor

Re: Date Transformations in Direct Query mode?

Hi Lydia Zhang:

Same question, how to transform to week of year format?

Thanks for answer.