calculate dates
1 Topic
Calculated Day Factor in Report Builder
I currently have a Calculated Measure in a PBI Desktop report that I'm trying to replicate in a different report that's in "MS Report Builder". ClcFtpRtTd = VAR CurrentDate = MAX('TimeDeposits'[TapeDate]) VAR DaysInMonth = DAY(EOMONTH(CurrentDate, 0)) VAR DaysInYear = YEARFRAC(DATE(YEAR(CurrentDate), 1, 1), DATE(YEAR(CurrentDate), 12, 31)) * 365 VAR AdjustmentFactor = DaysInYear / DaysInMonth RETURN IFERROR((SUM('TimeDeposits'[CLC_Withdrawal]) / SUM('TimeDeposits'[AvgBook])) * AdjustmentFactor, 0) How do I go about replicating/translating the calculated measure from PBI Desktop to a MS Report Builder report?Solved895Views0likes2Comments