I am trying to build formula to calculate forcast which should always show data from current month in next months.
There is a case that some products were not sold that month so pipvot table shows blank. I used below function and it works but if in current month there were no values for the product it show values from the first found month with values instead of blank.
Please help me how to solve it
Anything related to PowerPivot and DAX Formuale
2 posts • Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 3 guests