Forum Discussion
lennyt99
3 years agoHelper I
Volume Last year not working...
Greetings and thanks in advanced... I have volume categorized by fiscal year and now I want to display YOY and YTD, however it's not working. This is what I have for Volume Last Year: Volume...
- 3 years ago
lennyt99 Maybe:
Volume LY = VAR __Date = MAX('Fiscal Calendar'[Daily Date]) VAR __LYDate = EOMONTH(__Date,-12) VAR __LYEndDate = DATE(YEAR(__LYDate),MONTH(__LYDate),DAY(__Date)) VAR __LYDateStart = EOMONTH(__LYDate,-12) VAR __LYStartDate = DATE(YEAR(__LYDateStart),MONTH(__LYDateStart),DAY(__Date)) RETURN SUMX(FILTER('Opportunity Tracker 2.0',[Date]>=__LYStartDate && [Date]<=__LYEndDate),[Annual Volume LBS])You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008 - 3 years ago
Greg_Deckler Scratch that last post...
So it's displaying the correct abmount of volume last year, however no values are appearing?? This is odd
lennyt99
3 years agoHelper I
Greg_Deckler Scratch that last post...
So it's displaying the correct abmount of volume last year, however no values are appearing?? This is odd
lennyt99
3 years agoHelper I
Greg_Deckler Your amazing!!!!!!!!!!!!!!!!!!!!!!!!!!!!!