Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
IF('Calendar'[1-RollupQuardID] = ROUNDUP(MONTH(NOW())/3,0),TRUE, FALSE)
[1-Rollup DayMonth ID] -> ID to help group periods [1-Rollup Month] -> Assigns month name based on ID [1-Rollup Period] -> What will be used in the visual filter [1-Rollup Sort] -> Used to assign order to [1-Rollup Period] [1-isActiveRollup] -> The column I am attempting to use as a boolean for my issue [1-RollupQuarterID] -> Created this to test different methods of assigning a current date
Hi Ski900,
"this will not include the first 15 days of March, June, September and December. I have built the following columns relating to this problem (see below for link to dashboard):"
<--- Can't find the calculate column in your pbix file. Could you give some sample data with your expected result?
Regards,
Jimmy Tao
Thank you for the response! For the sample data let's assume that March 16th, 2018 is the current date.
Date RollupPeriod IsActiveRollupPeriod?
3-14-18 March 15th, 2018 False
3-15-18 March 15th, 2018 False
3-16-18 June 15th, 2018 True
Rollup Periods (essentially quarters starting in the middle of the month)
December 16th - March 15th rolls up to March 15th
March 16th - June 15th rolls up to June 15th
June 16th - September 15th rolls up to September 15th
September 16th - December 15ths rolls up to December 15th
If you have further questions please let me know! Thanks.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |