Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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