Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sb_powerbi
Helper II
Helper II

Direct Query Mode Create Month & Year from date field and display date with order

Hello ,

 

As per my anaysis Format function doesnt supported in direct query mode. I have create month year column(Jan'2017,Feb '2017...) one of the date field column. I am able to create it using Month,Year,Switch functions, but My challanging is need to display the monthly and yearly data with Order.  It would be great help if I get any suggestions on my requirement.

 

My Trails:

I have used If condtion like"(MontN0<10,"0"&MonthNo,MonthNo)" - Getting error messgae not support Dax in Direct query mode.

 

Please do the needful

 

1 REPLY 1
Eric_Zhang
Employee
Employee


@sb_powerbi wrote:

Hello ,

 

As per my anaysis Format function doesnt supported in direct query mode. I have create month year column(Jan'2017,Feb '2017...) one of the date field column. I am able to create it using Month,Year,Switch functions, but My challanging is need to display the monthly and yearly data with Order.  It would be great help if I get any suggestions on my requirement.

 

My Trails:

I have used If condtion like"(MontN0<10,"0"&MonthNo,MonthNo)" - Getting error messgae not support Dax in Direct query mode.

 


@sb_powerbi

Check this thread Sorting Data Manually

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.