Disconnected Time Dimension - count number of months

[Anonymous]

Hello friends,

I need to build a measure that calculates the number of months in the context of CalendarTable (disconnected)

So, if a user filters on a year - it will return 12, if a user filters on a quater, then - 3, month - 1

Please help with the logic

Thanks

Michael

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

---

I need to build a measure that calculates the number of months in the context of CalendarTable (disconnected)

So, if a user filters on a year - it will return 12, if a user filters on a quater, then - 3, month - 1

---

Do you mean the "Year", "Quarter" and "Month" column you're using as Slicers/Filters are from a different table(not the Calendar table)? Could you post some sample data for this table?

What if a user just filters on a month without selecting a specific Year or Quarter? Could you be more precisely with the logic you want to calculate the number of months? 

Regards

[Anonymous]

Thank you @v-ljerr-msft

I have just realized that I can use a simple DISTINCTCOUNT(CalendarTable[YearMonth]) since it is not connected to Fact

Thanks :)!

Michael

[BhaveshPatel]

Hi Micheal,

Please refer to the below blogpost by Rob collie oon Disconnected tables in Time calculations.

https://powerpivotpro.com/2013/06/simplifying-time-calculations-and-the-user-experience-using-discon...

[Anonymous]

@BhaveshPatel Thanks, but it doesn't reffer to my question.

I know how to create a disconnected time dimension.

I am asking for help on how to calculate a number of months.

So I need help with the logic for this specific measure.

Thank you!

Michael