Forum Discussion
Get measured value at a given time
Hello,
Many thanks for your help.
I managed to find the solution by creating a date table in power M using the following tutorial
Then, I added my table and created a custom column that check for each date if the record is for sale or not.
Thanks again everyone for your help and time!
Hi amitchandak .
Many thanks for your answer.
To which date column am I supposed to link the Date table? I can't see how this can work
To be clearer : I have an "Opened Date" and a "Closed date" column. I want to know the number of records opened at a given time, preferably with a monthly increment.
Community SupportHi， AlexisCohen88K
Not very clear.
If possible,can you share you sample pbix file or data for testing.
I make a sample file ,hope it can work for you.Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Many thanks for your help.
I managed to find the solution by creating a date table in power M using the following tutorial
Then, I added my table and created a custom column that check for each date if the record is for sale or not.
Thanks again everyone for your help and time!