Forum Discussion

posterme's avatar
posterme
Frequent Visitor
8 years ago

Slicer - How can I count selected months?

Hi Guys,   how can I or is it possible to count how many months I have selected in a Date-Slicer? I want to divide a value with the count of monts, e.g. earnings / selected months ... All variants ...
Need Help
YellOwBoyz's avatar
YellOwBoyz
New Member
8 years ago

There is certainly more optimize way to do it.

But for example you can duplicate your date column convert it into a type text, and concatenate the year and the month.

And then do a DISTINCTCOUNT of your new column.

 

Example of M query to get your year and month

Text.Range([Date], 6,4) & Text.Range([Date], 3, 2)

cylix's avatar
cylix
Regular Visitor
8 years ago

i too would like to know how to do this

  • posterme's avatar
    posterme
    Frequent Visitor
    7 years ago

    Hi cylix,

     

    till now I do not have a proper solution for that...

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, have you had any luck with this? I am tasked with doing something similar to this as well but the above solutions provided do not work. Please advise.

       

      Thank you. posterme