|Employee Key||Employee Name||Employee Group||Calendar Type|
|Project Key||Project Name||Project Type|
|1||some billable project||billable|
|2||some non-billable project||non-billable|
Dimension Week Calendar Type
|FY-Week-Calendar Type Key||FY-Week Key||Week||Calendar Type||Week Category||Fiscal Year|
Can you share the PBIX file? Also, if you need more than 20,000 characters, that is going to be a long post. That is about 40 typed pages.
Just share the PBIX via OneDrive, Dropbox, etc. along with the specific measure you are having an issue with and someone will jump in.
I think the 20k-character limit is being thrown erroneously, since a character count in Word is showing something much less than that. I get this error message quite often. Either way, I had to find a way around the error -- hence the several replies and picture for one of my data tables.
I don't have a file sharing option available to me. My company does have OneDrive, but we have blocked all external sharing in our tenant.
I was able to get a Google Drive account, and I posted my pbix file.
Fact Hours Worked