Forum Discussion

mwen90's avatar
mwen90
Icon for Helper III rankHelper III
7 years ago

Calculate per month

Hi,    I have a table which has the date an item was created. The item is created on a weekly basis on one day. Normally 50-100 items are created on that day.    I want to create a report for how...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi mwen90 

 

you might consider to create a pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file(Not just screenshot). Please do not forget to describe the expected results based on this sample data.

 

  • mwen90's avatar
    mwen90
    Icon for Helper III rankHelper III
    6 years ago

    Hey, 

     

    Apolgies for the delay. 

     

    I've attached a photo. Basically, I want to calculate how many times a company name has been entered for the current month. If it is more then 4, then I want a green box, if it is less, then red. 

     

    The issue is, I don't want to write a DAX for each company name as there could be thousands. So how do I calculate if the comapny name has been entered 4 times within the current month? 

     

    Thanks for the help! v-diye-msft Anonymous 

     

     

    Cheers,