How to calculate Number of month for in current year and Number of month for in current year+1

[mdaamirkhan]

Hi All,

I need help in dax to calculate the below 3 steps as I already mention Date below as I have Year from 2019 to 2023

1. Number of months

2. Number of month for in current year 
3.Number of month for in current year+1 

Date

1/12/2019

3/12/2020

3/1/2021

3/2/2021

3/3/2021

3/4/2021

1/12/2022

2/12/2022

3/1/2023

3/2/2023

[mdaamirkhan]

I forget to mention this one as well
Number of month for which contract is active since today
example we date and Active column where there in Yes and NO. How will I calculate

[mdaamirkhan]

Thanks it works and I forget to mention this one as well

Number of month for which contract is active since today

example we date and Active column where there in Yes and NO. How will I calculate

[mdaamirkhan]

Any idea on this Number of month for which contract is active since today
example we date and Active column where there in Yes and NO. How will I calculate

[amitchandak · Accepted solution]

@mdaamirkhan , Try a new

Best Create a new column

Month Year sort = FORMAT([Date],"yyyymm")

And they try a new measure like

Number of months= calculate(distinctCOUNT(Table[month year]))

Number of month for in current year= calculate(distinctCOUNT(Table[month year]), filter( Table, Year(Table[Date]) = year(Today())))

Number of month for in current year + 1= calculate(distinctCOUNT(Table[month year]), filter( Table, Year(Table[Date]) = year(Today())+1))