Calculated Day Factor in Report Builder

Question

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".&nbsp;&nbsp;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)) * 365VAR AdjustmentFactor = &nbsp;DaysInYear / DaysInMonthRETURN IFERROR((SUM('TimeDeposits'[CLC_Withdrawal]) / SUM('TimeDeposits'[AvgBook])) * AdjustmentFactor, 0) &nbsp;&nbsp;How do I go about replicating/translating the calculated measure from PBI Desktop to a MS Report Builder report?

anonymous · Accepted Answer

Hi,&nbsp;dashmarley11&nbsp;
Report Builder uses VB.NET-based expressions. You'll need to use the functions available in Report Builder to implement similar calculations.
CurrentDate=Max(Fields!TapeDate.Value)

DaysInMonth=DateDiff("d", DateAdd("m", 1, DateSerial(Year(Fields!TapeDate.Value), Month(Fields!TapeDate.Value), 1)), DateSerial(Year(Fields!TapeDate.Value), Month(Fields!TapeDate.Value), 1))

DaysInYear=DateDiff("d", DateSerial(Year(Fields!TapeDate.Value), 1, 1), DateSerial(Year(Fields!TapeDate.Value), 12, 31)) + 1

AdjustmentFactor =DaysInYear / DaysInMonth

The final=IIf(Sum(Fields!AvgBook.Value) = 0, 0, (Sum(Fields!CLC_Withdrawal.Value) / Sum(Fields!AvgBook.Value)) * AdjustmentFactor)
&nbsp;
&nbsp;You can create a calculated field or use these expressions directly in a report item (e.g., text box, table).
&nbsp;
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Calculated Day Factor in Report Builder

2 Replies

Related content

Report Builder - Export failed

Calculating bradford factor

PowerBI Report builder

Bradford factor Calculation

Calculating a factor