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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
joshua1990
Post Prodigy
Post Prodigy

Number of new orders based on yesterday and today values

Hello everyone!

I have an archive of our sales order table with a snapshot of every day.

The table has this structure:

Order NumValueDate requestedQuantityCustomer IDTimestamp
10050001.07.20215000AB101.07.2021
10050001.07.20215000AB102.07.2021
10160001.08.20214000AB102.07.2021

 

Now I would like to determine how many new orders are in this table compared to the previous day.

How would you do that?

1 REPLY 1
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @joshua1990 ,

Try using this:

Calculated column:  Status of Order= IF(Timestamp = TODAY(), "New order")
No of new orders= COUNT( Status of Order)


If this answers your question, please mark this as a solution!

Thankyou!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors