Forum Discussion
How to make a slicer modify a measure
First, thank you so much for all the help you are providing us! We are so appreciative of it.
We applied these measures in our model, but our reporting periods are dates so it's returning funky results. They are not assigned 1,2 as in your pbix file. Could you help modify the measure so it works with and first of month date? i.e. 012021, 022021, 032021 date format?
Community SupportHi, shelleye
I'm a little confused, your needs don't seem to have anything to do with the date. How did you get the different results? Do you have any other factors that need to be considered?
What if the data table has revenue centers and multiple reporting periods and the request is to calculate the % of the Account description 1 by Operating Income for each individual period and revenue center?
Please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't know how to upload our sample pbix file with my options available in this reply.
Thank you v-angzheng-msft
I have a sample .pbix file that I hope will be helpful. On this file I created a visual using a measure that only looks at Salary Expense and another visual using the dynamic measure you provided to compare results.
I've included the link to the onedrive.
Thank you again for your help,
best regards,
