Forum Discussion
admin11
Memorable Member
Memorable MemberHow to modify my Expression return Amount from Jan till Mar ?
Hi All
Below expression work fine , it return Jan till April amount = 4 million
Target YTD =
var _max = today()
return
calculate(TOTALYTD(('TARGET_'[TARGET_]),'Date'[Date]),filter('Date','Date'[Date]<=_max))
May i know how to modify the above expression , so it will return Jan till March amount = 3 million.
My PBI file :-
https://www.dropbox.com/s/b0dms6jpis9gqaq/PBT_V2021_400%20TS_SI%20SAMPLE.pbix?dl=0
Paul
