Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
I'm busy recreating a timesheet from our previous reporting tool to Power BI and I had a weird issue.
In my matrix, I can add multiple levels. For this one I have 4 levels coming from a Date-Table:
- Month Name (Long)
- Week
- Day_Of_Week_Short (calculated column POST Query)
DAY_OF_WEEK_Short = LEFT(TimeFields[DAY_OF_WEEK];1) & LOWER(RIGHT(LEFT(TimeFields[DAY_OF_WEEK];2);1))
- Daynumer of Month
However the simplest change already gives errors. I tried switching "WEEK" with "WEEK_NR". A calculated column that is defined as follows:
WEEK_NR = "Week " & TimeFields[WEEK]
But that gives the following, unsatisfying result:
I've checked the syntax of WEEK_NR but didn't find any errors.
Even weirder is that if I'm filtering our certain WEEK_NRs I get more data and kind of what I want!
Is this a bug? What am I doing wrong? If the calculated column is doing so much damage, why is the "Day_Of_Week_Short" Not giving any troubles?
Additional Info:
- The value I'm using is in a different query to trhe dates-query. They're linked in a many to one relationship that cross-filters both ways.
- I've tried changing August to "August 2018" in a similar way and this resulted in a similar error.
Hi @matthias_vc
Based on my test, I cannot reproduce the same issue as you said. It's better to share some simplified data sample. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |