Forum Discussion

2 Replies

  • 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