Forum Discussion
dax formula
i have a the following data 1) numbertable below (numbertable) 2) a column of MMYY (date) 3) column with all the value for MMYY (values) In my scenario, User select an option for MMYY and nu...
Anonymous
Thank you, I modified the file a bit (added added a date table and updated the measure) and attached it.
jdbuchanan71
need your help again.
I tried the forumla but it doesnt seem to give me the correct value.
For example if i select Product A, Jan-Aug, total sales = 445
if user selected number '8', the answer should be 667.5 instead of the following?
Anonymous
Please share your .pbix file, the one you took the screen shot from so I can see how you have the model and report set up.
Here it is
jdbuchanan71Anonymous
Thank you, I modified the file a bit (added added a date table and updated the measure) and attached it.
Thank you so much!It worked.