I have a table attached to a date dimension where I want to count the number of duplicates of Column1 - figure it to be an integer.
A value in Column1 repeats itself without any kind of patter. I need to figure out how many times a value repeats itself but only repeats itself after X amount of months.
So 555 duplicate count would equal 1, and 556 would be 2.
I'd assume there must be some kind of DAX that can be used for this formula however I haven't been able to figure it out exactly.
You may add a measure as follows.
VAR d = Table1[Date]
>= DATE ( YEAR ( d ), MONTH ( d ) - 1, 1 )
&& Table1[Date] < d
I'm trying this now @v-chuncz-msft, but am not seing the measure once I pusblish the tabluar model and refresh Power BI.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.