[MonthBill], 0 ) ) ) RETURN IF ( selectedtime < starttimemonth, BLANK (), IF ( selectedtime < ( starttimemonth + 365 ), FORMAT ( AVERAGEX ( FILTER ( t1, [Month] <= selectedtime ), [MonthAtt] ) * 12, "Percent" ), FORMAT ( DIVIDE ( SUMX ( FILTER ( t1, AND ( [Month]...
RETURNTotal*** LastCurrentDate = MAX('Date'[Date]) *** Total ListPrice = SUM(Training2[ListPrice]) Message 2 of 10 1,281 Views 0 Reply Anonymous Not applicable In response to Mahesh 12-15-2022 03:15 Hi Mahesh I have tried applyingthis in M Code in PQ and...
[SOW] IN FILTERS ( SOWMaster[SOW] ) ), [Last Working Day] ) RETURN IF ( selectedtime < starttime, BLANK(), IF ( selectedtime < ( starttime + 365 ), FORMAT ( DIVIDE ( totalnos, totalbill, 0 ) * 12, "Percent" ), FORMAT ( CALCULATE ( [12 month Attrition Nos] / [12...
[SOW] IN FILTERS ( SOWMaster[SOW] ) ), [Last Working Day] ) RETURN IF ( selectedtime < starttime, BLANK(), IF ( selectedtime < ( starttime + 365 ), FORMAT ( DIVIDE ( totalnos, totalbill, 0 ) * 12, "Percent" ), FORMAT ( CALCULATE ( [12 month Attrition Nos] / [12 month...
[SOW] IN FILTERS ( SOWMaster[SOW] ) ), [Last Working Day] ) RETURN IF ( selectedtime < starttime, BLANK(), IF ( selectedtime < ( starttime + 365 ), FORMAT ( DIVIDE ( totalnos, totalbill, 0 ) * 12, "Percent" ), FORMAT ( CALCULATE ( [12 month Attrition Nos] / [12 month...
[SOW] IN FILTERS ( SOWMaster[SOW] ) ), [Last Working Day] ) RETURN IF ( selectedtime < starttime, BLANK(), IF ( selectedtime < ( starttime + 365 ), FORMAT ( DIVIDE ( totalnos, totalbill, 0 ) * 12, "Percent" ), FORMAT ( CALCULATE ( [12 month Attrition Nos] / [12 month...