Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created this data using calculated measure and know I want to measure sum for each running month For rep_month.
example :
for 1st column 2nd column and 3rd measure
For Jan I need sum of all jan
feb sum of jan+ feb
march- sum of jan+feb+march
april= sum of jan+feb+march+april
Hi @Anonymous ,
It is hard to coding formula without any detail information, please share some sample data for test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Here is the sample data for creating a measure. From this data, I have created a measure for each Rollup location and NPSCAT
I have used below formula for creating measure.
Hi @Anonymous ,
You can try to use following measure formula:
_Measure = CALCULATE ( [promoter Measure] + [Passive Measure] + [Decorate Measure], FILTER ( ALLSELECTED ( 'all data' ), 'all data'[Rep_Date] <= MAX ( 'all data'[Rep_Date] ) && INT ( MONTH ( 'all data'[Rep_Date] ) / 3 ) + IF ( MOD ( MONTH ( 'all data'[Rep_Date] ), 3 ) > 0, 1, 0 ) = INT ( MONTH ( MAX ( 'all data'[Rep_Date] ) ) / 3 ) + IF ( MOD ( MONTH ( MAX ( 'all data'[Rep_Date] ) ), 3 ) > 0, 1, 0 ) ) )
Regards,
Xiaoxin Sheng
I need to add 3 consecutive months from the above data. I have to calculate the \
jan = jan
feb = Jan+feb
march = jan+feb+march
april = feb+march+april
may = march+april+may...... so on upto december
I'm new to power bi. please help me out for the above measure.
HI @Anonymous ,
Please try to use following measure if it works, I modify conditions to summary rolling three month records:
_Measure = CALCULATE ( [promoter Measure] + [Passive Measure] + [Decorate Measure], FILTER ( ALLSELECTED ( 'all data' ), 'all data'[Rep_Date] <= MAX ( 'all data'[Rep_Date] ) && MONTH ( 'all data'[Rep_Date] ) >= MONTH ( MAX ( 'all data'[Rep_Date] ) ) - 2 && MONTH ( 'all data'[Rep_Date] ) <= MONTH ( MAX ( 'all data'[Rep_Date] ) ) ) )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |