Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Aleiadeh
Frequent Visitor

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)

 

1.jpg

 

Thank you in advance

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

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
Community Champion
Community Champion

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?

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors