How to calculate row count difference based on date

[Aleiadeh]

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

[v-luwang-msft]

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

[PC2790]

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]

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