Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
98 | |
80 | |
75 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |