Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Employee Key | Employee Name | Employee Group | Calendar Type |
1 | John Doe | one | A |
2 | Jane Doe | two | B |
Dimension Project
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 |
2019-2020-1-A | 2019-2020-1 | 1 | A | a | 2019-2020 |
2019-2020-2-A | 2019-2020-2 | 2 | A | b | 2019-2020 |
2020-2021-1-A | 2020-2021-1 | 1 | A | a | 2020-2021 |
2020-2021-3-A | 2020-2021-3 | 3 | A | b | 2020-2021 |
2019-2020-1-B | 2019-2020-1 | 1 | B | x | 2019-2020 |
2019-2020-2-B | 2019-2020-2 | 2 | B | y | 2019-2020 |
2020-2021-1-B | 2020-2021-1 | 1 | B | x | 2020-2021 |
2020-2021-3-B | 2020-2021-3 | 3 | B | y | 2020-2021 |
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI 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.
https://drive.google.com/file/d/1orQx8T-5MzPxDlDLqx0KG2kG3uS5tLf6/view?usp=sharing
Fact Hours Worked