cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryankahn
Frequent Visitor

Having trouble converting the following sql query into dax. Any help much appreciated!

Hello All,

 

I am pretty new to power BI and am having trouble converting the following sql query into Dax. Any help much appreciated!

 

select tms_procurement_field_values.procurement_request_id, tms_procurement_field_values.value  
FROM tms_procurement_field_values, vw_tms_procurement_requests, vw_tms_tickets 
WHERE vw_tms_procurement_requests.id = tms_procurement_field_values.procurement_request_id 
and vw_tms_tickets.id = vw_tms_procurement_requests.ticket_id 
and vw_tms_tickets.customer_id = 4145 
and tms_procurement_field_values.field_id = 38174 
and vw_tms_procurement_requests.purpose_name = 'Complimentary Event' ;
2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi ryankahn,

 

What's the relationship between tables tms_procurement_field_values, vw_tms_procurement_requests and vw_tms_tickets? Which ones are dimensional tables and which one is fact table? If you have no need to achieve aggregation value, it's simple to achieve this, drag columns [procurement_request_id] , [value] and id from two tables into a same chart, then use visual level filter to set some filters: vw_tms_tickets.customer_id = 4145 , tms_procurement_field_values.field_id = 38174 , vw_tms_procurement_requests.purpose_name = 'Complimentary Event'

 

Regards,

Jimmy Tao

Greg_Deckler
Super User
Super User

If you use the Advanced option when connecting to SQL Server you can just paste in your SQL code.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!