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

Try:

 

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

 

--Nate

 

 

Sai_Kumar's avatar
Sai_Kumar
Frequent Visitor
5 years ago

Hi Watkinnc,

Thanks for considering!

I tried the way as you said 

The error follows-
Too few arguments were passed to the USERELATIONSHIP function. The minimum argument count for the function is 2.