Forum Discussion

Sai_Kumar's avatar
Sai_Kumar
Frequent Visitor
5 years ago

Hello everyone, I need an help Regarding Power Query/Dax in Power BI

Hi Guys,  Morning! I am working on Sales data and the data has Open Order Sales by Doc_date and Doc_due_date in the MCS_PowerBI_Fact table.   Requirement: I am looking for an Open Order Sales vis...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry--copy/paste error:

 

OpenOrderSales = CALCULATE(SUM([OpenOrderSalesAUD]), DISTINCT('MCS_POWERBI_FACT'[DocDueDate]), USERELATIONSHIP('MCS_POWERBI_FACT'[DocDueDate],'Master Calendar'[Date]))

Sai_Kumar's avatar
Sai_Kumar
Frequent Visitor
5 years ago

I tried it - But, the measure output was the same as my last measure as mentioned in the post.

  • Sai_Kumar's avatar
    Sai_Kumar
    Frequent Visitor
    5 years ago

    If you see the Doc_Date and Doc_Due_Date columns 
    The requirement was, we need to extract only Doc_Due_date if Doc_Due_date was in the Current month.

     

    The OLD_Open Order Sales measure was working but giving us all open order Sales - where we need only present and future months open order sales.  

    • v-yingjl's avatar
      v-yingjl
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Sai_Kumar ,

      Consider using Crossfilter() to change the cross filter direction or change it manually in the relationship view to check whether it works.

      Plesae refer: Bi-directional relationship guidance 

       

      If it still has the same issue, you can consider sharing a simple sample file without any sentive information for further discussion.

       

      Best Regards,
      Community Support Team _ Yingjie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.