Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
I have another table called 'Week', which I created and input those values' to help identify each day of the week.
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
@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/
Thank you for the reply. For the measure is this for the SharePoint table or the Date table I created.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |