topic Active Month In Use in DAX Commands and Tips

Active Month In Use

bolarinwa — Wed, 12 May 2021 07:53:53 GMT

Hi, I created a calculated column Mont h in use which calculates the number of Months from the service data for each location e.g column 1 is the first service Month and column 6 is 6 Months after. However, I want each next Month to be Months when the service is active, that is only when there are values. For example in row 1 values in months 14-19 should be in columns 6-12.

Below is my dax code

Months in Use (Location) = FLOOR(DATEDIFF(RELATED(categories[First Feedback]), RELATED('Time'[Start Of Day]), DAY) / (365/12), 1) + 1

Please help.

Re: Active Month In Use

amitchandak — Wed, 12 May 2021 08:19:09 GMT

bolarinwa , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer if this can help

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

Re: Active Month In Use

bolarinwa — Wed, 12 May 2021 08:28:08 GMT

This is a sample of expected output as compared to the previous table I posted.

Re: Active Month In Use

bolarinwa — Wed, 12 May 2021 08:57:02 GMT

These are the example of input data