PeopleSoft Query to Power BI DeskTop/DAX

[MABI]

Hi All,

I am new in this arena, appreciate your help in translating following PeopleSoft query in to Power BI desktop or DAX.

We are trying to replace some PeopleSoft queries with Power BI solution and have direct query connection with Oracle 11

SELECT A.COMPANY, A.PAYGROUP, PS_PAY_OTH_EARNS B

FROM PS_EXE_PAYMENT A, PS_PERSONAL_DATA B

WHERE A.PAY_END_DT BETWEEN TO_DATE(DATE1, 'YYYY-MM-DD') AND TO_DATE(DATE2, 'YYYY-MM-DD')

AND A.OFF_CYCLE = 'N'

AND A.COMPANY = B.COMPANY

AND A.PAYGROUP = B.PAYGROUP

AND A.PAY_END_DT = B.PAY_END_DT

AND A.EMPLID = 'Employee ID'

AND B.ERNCD NOT IN ('OTP','STP')

Here Employee ID, DATE1 and DATE2  are input parameters

Thanks in advance

[MFelix]

Hi @MABI ,

Don't really understand the question you are having, you want to have a dinamic query that based on selection returns the data?

Or do you want to make the visualizations based on an overall table and use parameters to return the values?

Currently there is an option to have queries impacted by slicers in a report so that could be what you need.

The query you have send out is a view you are using to create your data?