postgresql
1 Topic
Need DAX from PostgreSql query
Hi, This is Alam here, I am sort of new to Power BI and this DAX stuff. Although it is very interesting at the same time i'm getting stuck in certain cases where I am finding any proper resources to solve my problem. I would really appreciate if anyone can help me convert the following PostgreSql query into DAX. The query is: WITH CurrentWeek AS ( SELECT DISTINCT id, sample_requested_by FROM designer_activity_dashboard_view where publish_date >= date_trunc('week', CURRENT_DATE) AND publish_date < date_trunc('week', CURRENT_DATE) + INTERVAL '7 days' ) SELECT sample_requested_by, cuv.name , COUNT(*) AS This_Week_TechPack_Published FROM CurrentWeek JOIN crm_user_view cuv ON CurrentWeek.sample_requested_by = cuv.id GROUP BY sample_requested_by, cuv.name ORDER BY sample_requested_by Would really appreciate your quick response and thanks in advance Sincerely AlamSolved908Views0likes1Comment