Forum Discussion

Resolver I

6 years ago

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...

Data Protection

Mariusz
6 years ago
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

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

Super User

6 years ago

MYDATASTORY , connect all three dates with a common date table, there will one active and two inactive joins. Use userelation to handle that.

Refer example how two handle more than one dates with the same date table.

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

Appreciate your Kudos.