Forum Discussion
Anonymous
5 years agoNot applicable
Working with Dates - Power BU Measure
I am working on a Power BI report, where I have a Date Hiearchy with dates in / across multiple years for an inventory solution... Qty on hand and qty shipped.
I need to show inv and qty shipped... as two of my columns... then i need to show totals for last 3 years... 2019, 2020 and current year.
I am trying to write a measure that would filter the inv date hiearchy bya specific year (2019) and only pull the year value from the hiearchy.
Thanks in advance
1 Reply
- parry2kSuper User
Anonymous not sure if I understood your question, maybe post sample data and required output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490