Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
DK2017
New Member

Users activity

Hi everyone, I am struggling to find the best solution for my problem. I would like to show the number of inactive users who werent active for the last 12 months but before that they have 1, 2, 4 + orders. How shall I write DAX syntax? The most critical columns are order date and customerID.

 

Thank you for you help!

1 REPLY 1
TheoC
Super User
Super User

@DK2017 every solution is different and is based on the data that each individual is working with.  Can you please add some data to provide context and, from there, you will find that the Community will be able to assist you better.

 

Thanks in advance

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.