topic Re: help with a date colum in DAX Commands and Tips

help with a date colum

Krijgersss — Wed, 28 Feb 2024 08:34:08 GMT

Hello i need some help with a date Colum. i have a date colum that gives a date of a shop if its open. so if there is a date the shop will be open. how do i count the days in that colum that i know how many days each month the shop is open.

many thanks

Re: help with a date colum

timalbers — Wed, 28 Feb 2024 08:46:48 GMT

Hi Krijgersss try something like this within a new measure:

new_measure = DISTINCTCOUNTNOBLANK( your_table[Date_column] )

Re: help with a date colum

Krijgersss — Wed, 28 Feb 2024 08:58:13 GMT

Thats not excatly what i want now it gives me only 1 by every date i want it to count so for example:

1-1-2024 1

2-1-2024 2

4-1-2024 3

5-1-2024 4
6-2-2024 1

7-2-2024 2

so in January the shop was 4 days open and in february the shop was 2days open

Re: help with a date colum

timalbers — Wed, 28 Feb 2024 14:00:02 GMT

I wonder, how you would like to display this data.
If you want to display it in a table visual, then just add another calculated column to your data that gives you the month and then you could use this field in your table visual combined with the measure I posted. Then you will have the exact number of days found for every month.

Re: help with a date colum

Anonymous — Thu, 29 Feb 2024 07:13:56 GMT

Hi Krijgersss ,

You can create calculated columns and write dax expressions:

Column = CALCULATE(COUNT('Table'[date]), FILTER(ALL('Table'), EARLIER('Table'[date]) >= EOMONTH('Table'[date],-1)+1 && EARLIER('Table'[date]) <= EOMONTH('Table'[date],0) && ' Table'[date] <= EARLIER('Table'[date])))

The result obtained is shown below:

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.