Forum Discussion
djreyes
2 years agoHelper I
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...
- 2 years ago
Right, it should autometically come into slicer and hence in report.
If this resolves your problem, then please mark this as solution, Thanks!
samratpbi
2 years agoSuper User
Hi, if you want to return no of years when selected, you can simply remove the + 1 in the measure. I thought you would need 730 if 1 year selected. Hence there is a + 1 with count years.
djreyes
2 years agoHelper I
Thank you so much! It works now, last question, so if a new year is added I dont need to do anything right?
- samratpbi2 years agoSuper User
Right, it should autometically come into slicer and hence in report.
If this resolves your problem, then please mark this as solution, Thanks!