Forum Discussion
Solved
Year Computation
Hello, I have a measure added in powerbi = ([QTY negative to positive max per item]*3)/365*([average qty]*1.2) How do I make the 365 change that when they select a year filter it will become 730 i...
Right, it should autometically come into slicer and hence in report.
If this resolves your problem, then please mark this as solution, Thanks!
Don't use fixed numbers. Have a calendar table in your data model and count the date rows for your selected years.