Forum Discussion
Help with DAX formula
Hello everyone, I want the below formula defined in a measure to group by month, but the dax'es I've tried is unable to group it by month. Hit_Rate%_15th = DIVIDE(COUNTROWS(FILTER('Placement S&OP...
Hi rit_ty7
Please provide a workable sample data (not an image), your expected result from that and the reasoning behind. Please refer to this post. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I'm unable to share sample data as the data is huge, previously we were calculating hit_rate for 1 month so that was not a problem but now we're working with 3 month's data and the formula is not filtering correctly.
A sample data doesnt have to be the actual data but a representation of what the actual is. The link in my initial reply should have a guide.