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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kitti
Helper III
Helper III

Always show data 10 days

Hi experts,

 

I have a date table and my another data table. How do I show data for 10 days excluding holidays? For instance, the report displays data on day 9-19 because day 10 and 11 are holidays.

 

 

Many thanks,

KL

1 ACCEPTED SOLUTION
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @kitti ,
Create another column where you display the dates for which you are having data in the table.
Dates_new= IF(column_name= BLANK(), BLANK(), Dates)
Then use this Dates_new column to get the Top 10 Days. 
You can use the Top N filter on the visual. 


View solution in original post

1 REPLY 1
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @kitti ,
Create another column where you display the dates for which you are having data in the table.
Dates_new= IF(column_name= BLANK(), BLANK(), Dates)
Then use this Dates_new column to get the Top 10 Days. 
You can use the Top N filter on the visual. 


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors