Forum Discussion

AlexisCohen88K's avatar
AlexisCohen88K
Frequent Visitor
5 years ago
Solved

Get measured value at a given time

Hello,   I'm trying to calculate the number of Houses which was "For sale" at a given time.   My Columns are : House ID, Date to Market, Date Sold. The result expected would be something like a ...
Need Help
  • AlexisCohen88K's avatar
    AlexisCohen88K
    5 years ago

    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!

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi， 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.

 

AlexisCohen88K's avatar
AlexisCohen88K
Frequent Visitor
5 years ago

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!