Forum Discussion

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Ramireddy123,

 

Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue?

 

It's better to share a dummy pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards

Ramireddy123's avatar
Ramireddy123
Frequent Visitor
8 years ago

select    DATE_PART('year', a11.claim_date::date) AS YEAR_PART,
    a11.current_claim_status AS current_claim_status,
    a11.current_claim_status AS claims_processing_stage_id,
    a12.claim_status_id AS claim_status_id,
    count(distinct a11.claim_id) AS WJXBFS1
from    public.claims    a11
    join    public.claimsprocessingstages_master    a12
      on     (a11.current_claim_status = a12.claims_processing_stage_id)
where    a12.claim_status_id in ('CLS_001')
group by    DATE_PART('year', a11.claim_date::date),
    a11.current_claim_status,
    a11.current_claim_status,
    a12.claim_status_id

 

i want same output with DAX