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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Monday-Sunday week table/datacard to show whether a record is submitted through SharePoint

Hi all,

 

I hope you are doing well.

 

I am trying to build a visual where it can track whether a record is submitted to a SharePoint on certain day of the week. For example, if there is a record submitted on Monday have the Monday datacard t o say "Yes". If there are no records submitted on Tuesday, have the Tuesday datacard to say "No". 

 

I created a seperate calendar table 

Vinod29_3-1652349277685.png

 

I also created another column called 'Fomat' to distinguish what day of the week it is.

 

My problem is the If column. Here I want to say IF a record is submitted through my SharePoint on that specific date from the 'Date' column put 1 otherwise put 0. If thats possible I could use that column to filter through each of the datacards for each day.

 

The SharePoint data is from another Table 

 

Vinod29_4-1652349579902.png

 

I have another table called 'Week', which I created and input those values' to help identify each day of the week.

 

Vinod29_5-1652349724530.png

I have another measure as well to help filter through "Yes" and "No". The main issue is the If column its not registering my SharePoint data table so I don't know how to write 'IF[SharePointData table] shows a record on that date specific date on the 'Date', 0, 1].

 

Any help would be much appreciated.

 

Kind regards, 

Cevin Vinod 

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Join your table with Date Table and Create a measure

 

Countrows(Table) +1

 

Otherwise, try merging in power query with a date table (Create date table in power query)

Date Table in Power Query: https://youtu.be/so_A22HXbwM

Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16

 

or check -https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Anonymous
Not applicable

Thank you for the reply. For the measure is this for the SharePoint table or the Date table I created. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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