Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Could you please help me to build fomular for this?
I want to have no of days finished each moth.
So it is 18 Mar today, I want to get 18 in 1 Mar column.
April has not started yet, I want to show zero. Thank you for your help as always!
Month Days
1 Jan 2018 31
1 Feb 2018 28
1 Mar 2018 18
1 Apr 2018 0
All the best,
cocomy
Solved! Go to Solution.
Zubair_Muhammad,
Perfectly worked. Thank you very much for your help!
All the best,
cocomy
Hi @cocomy
You can try this calculated column
days = VAR MonthEnd = EOMONTH ( Table1[Month], 0 ) VAR EndDate = IF ( MonthEnd > TODAY (), TODAY (), MonthEnd ) RETURN IF ( EndDate > Table1[Month], DATEDIFF ( Table1[Month], EndDate, DAY ) + 1, 0 )
Zubair_Muhammad,
Perfectly worked. Thank you very much for your help!
All the best,
cocomy
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |