Forum Discussion
Need help with DAX formula
Hello Everyone,
I've two date tables in my PBIX file i.e Order Date and Delivery Date
And I want to calculate the number of orders placed in number of orders placed in June for Delivery in June.
Please help me with the DAX formula.
Thanks in advance
Warm Regards,
Harsh
Anonymous As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.
https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/set relationship between these two deliver and order date with date dimension table and one of the relationship will be inactive, in this example I assume order date relationship is active and the delivery date is inactive, add the following two measures
Order Count = COUNTROWS ( OrderTable ) Delivery Count = CALCULATE ( [Order Count], USERELATIONSHIP ( OrderTable[DelieveryDate], DateTable[Date] ) )to visualize, use month from date table, and above two measures and you will get the count by order date and delivery date.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
1 Reply
Anonymous As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.
https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/set relationship between these two deliver and order date with date dimension table and one of the relationship will be inactive, in this example I assume order date relationship is active and the delivery date is inactive, add the following two measures
Order Count = COUNTROWS ( OrderTable ) Delivery Count = CALCULATE ( [Order Count], USERELATIONSHIP ( OrderTable[DelieveryDate], DateTable[Date] ) )to visualize, use month from date table, and above two measures and you will get the count by order date and delivery date.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡