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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
LJ16923
Frequent Visitor

Direct Query Converting Number To Text

Hi there, 

 

I'm producing a simple report for work that must include slicer buttons for each day of the week so management can easily view sales trends for each day of the week. 

 

I've managed to use the weekday function to convert the dates to numbers 1-7 (mon-sun) but I want to now convert these numbers to text e.g. IF( day=1, "Monday", IF(day=2, "Tuesday, .... etc. 

 

This doesn't work as I'm trying to convert numbers to text. 

 

I'm using direct query so I cannot use the convert or format functions. 

 

Also there is no checkbox option to allow unrestricted measures via direct query in the data source options (seen this suggestion in other threads)

 

This is a relatively simple formula and for some reason finding impossible to achieve - any help will be much appreciated. 

 

Essentially just need to find a way to convert numbers to text when using a direct query data source. 

 

Cheers,

 

Louis

 

 

1 REPLY 1
amitchandak
Super User
Super User

@LJ16923 , what error does it show?

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors