Forum Discussion

Aleiadeh's avatar
Aleiadeh
Frequent Visitor
5 years ago

How to calculate row count difference based on date

Good Day;

 

Please I need a solution how to get the rows count detla between two dates.

 

I have simple unpivot table including three column (Bid No. , Date, Bid Status).

 

As per the below photo I make a new measure to calculate the No. of new bids, and its working fine until I select Jan. 18, 2021 then the result will be blank.

 

I know my measure will be working fine if the date column are idintecal and the difference between the dates are 7 days.

 

So, Could anyone support me and give me a dax that can give me the row count detla between two dates dispit how much the difference days between the dates ( This Date and Previous Date)

 

 

Thank you in advance

Need Help

3 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hello Aleiadeh,

     

    Will you be able to provide your sample data?

    Is the Date column in your table has date values at a difference of 7 days?

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hello PC2790 ,

       

      in addition to the questions from Aleiadeh , did you mark your datetable as datetable?

      If not you have to add an ALL(TimeStatus) to you CALCULATE statements.

       

      If you need any help please let me know.
      If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

      Best regards
      Denis

      Blog: WhatTheFact.bi

       

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    Hi Aleiadeh ,

    Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
     
    Best Regards
    Lucien