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
Talal141218
Helper III
Helper III

Stock quantity counting yesterday and today

Hi there, 

i want your help, i want to great a measure to calculate how many sock in warehause yesterday or today ? 

 

Thanks in Adavnce 

1 ACCEPTED SOLUTION
v-mengzhu-msft
Community Support
Community Support

Hi @Talal141218 ,

 

Since lacking of your sample data , I created a simple table for testing, I hope you find it useful.Like this:

 

my data:

vmengzhumsft_0-1664354419610.png

create a visual and change data type as "sum"

vmengzhumsft_1-1664354547586.png

you can create a slicer to filter "sock", then get result:

vmengzhumsft_3-1664354612679.png

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

View solution in original post

2 REPLIES 2
v-mengzhu-msft
Community Support
Community Support

Hi @Talal141218 ,

 

Since lacking of your sample data , I created a simple table for testing, I hope you find it useful.Like this:

 

my data:

vmengzhumsft_0-1664354419610.png

create a visual and change data type as "sum"

vmengzhumsft_1-1664354547586.png

you can create a slicer to filter "sock", then get result:

vmengzhumsft_3-1664354612679.png

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

daXtreme
Solution Sage
Solution Sage

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