Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Experts,
I am new in Power BI - trying to explain my prob I am facing,
I wanted to bifurcate month from date Rate. i.e
Project start date - 1st Jan'18 to 31st Dec' 19 - so # of month i want in 2018 column = 12 & 2019 = 12
so on each row of the table, I want no of Month in Column wise (in Year formate)
Thanks
Kaush
Solved! Go to Solution.
Hi @rekaush
You could try the following calculated column. Just change the VAR myYear variable to 2019 for the 2019 column
2018 Month = VAR myYear = 2018 VAR Months = SUMMARIZE( ADDCOLUMNS( CALENDAR( DATE(myYear,1,1), DATE(myYear,12,1) ), "Month", DATE( YEAR([Date]), MONTH([Date]), 1) ) ,[Month]) RETURN COUNTROWS( FILTER( Months, [Month]>=EARLIER(Projects[Project Start Date]) && [Month] <=EARLIER('Projects'[Project End Date]) ))
Hi @rekaush
You could try the following calculated column. Just change the VAR myYear variable to 2019 for the 2019 column
2018 Month = VAR myYear = 2018 VAR Months = SUMMARIZE( ADDCOLUMNS( CALENDAR( DATE(myYear,1,1), DATE(myYear,12,1) ), "Month", DATE( YEAR([Date]), MONTH([Date]), 1) ) ,[Month]) RETURN COUNTROWS( FILTER( Months, [Month]>=EARLIER(Projects[Project Start Date]) && [Month] <=EARLIER('Projects'[Project End Date]) ))
Thx Mate, Really helpful 🙂
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |