Table per week / Data from Sharepoint list - not showing up

[Anonymous]

Hi everyone,

I'm trying to implement a tracking on operations I'm clearing/week. I have a sharepoint list which looks that way :

From a Power BI perspective, I would like to have the ''Due Date'' column in a table which could look like this.

Nothing fancy, and I dont think it's that complicated, so I used some DAX expressions as per below :

Test =

GENERATE (

CALENDAR ( DATE ( 2021, 1, 1 ), DATE ( 2021, 12, 31 ) ),

VAR currentDay = [Date]

VAR day = DAY( currentDay )

VAR month = MONTH ( currentDay )

VAR year = YEAR ( currentDay )

RETURN ROW (

"day", day,

"month", month,

"year", year )

)

Problem is my data dont show at all on the table, and I cant figure out where I messed up ?

If somebody has an idea on how I could solve this ''issue'', I'd be really glad 🙂

Have a nice day all

[themistoklis]

Hello @Anonymous ,

When you created the Date table have you linked it with the relevant table in 'Model' section?

E.g. Creating a connection between "Rework Process" and Test (Date) table:

Rework Process[Due_date] = Test[Date]

[Anonymous]

Hello,

That's indeed a good start that I forgot..

It's showing blanks now

I guess i'm on the right path, but I would require a bit more help!

Thanks a lot for taking care of it, much appreciated !

[themistoklis]

@Anonymous 

Make sure that the join field on both tables is on Date format (not Datetime or anything else)

Any chance you could share the workspace with us?

Please remove any sensitive data