Forum Discussion
Solved
How to count current stock
Hi, I have a simple query, on a count, but not sure which of these functions I should; Count; COUNTAX; I would like to accomplish below; I would like to show this month by month. Metadata: Bought...
Hi MYDATASTORY
You can create a date dimension ( if you haven't got one ) create relationships between all dates and later use USERELATIONSHIP function in your measures to count the events.
Date dimension example
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
USERELATIONSHIP
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Hi MYDATASTORY
You can create a date dimension ( if you haven't got one ) create relationships between all dates and later use USERELATIONSHIP function in your measures to count the events.
Date dimension example
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
USERELATIONSHIP
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.