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.
Hi all,
I believe it is simple but I need your help as I am stucked.
Here is what i have:
Underreported hours are marked with red and are negative values. Over/Underreported column is a sum by month.
What I want to do is to create a filter for Over/Underreported column:
Hi @maryJ ,
By my tests and research, I'm afraid that your calculated column formula will not work in Direct Query Mode.
You'd better create the measure with that formula in direct query mode, it should be work by my test.
You could have a good look at these limitations before you use Direct Query.
I' m afraid that you may try to create a custom column in Query Editor. Please refer to the formula below.
= Table.AddColumn(#"Added Custom", "Custom.1", each if [Custom]>8 and [Custom]<16 then ">8" else if [Custom]>16 then ">16" else "less than 8")
Best Regards,
Cherry
Hi @v-piga-msft ,
Thank you very much for your response.
I appreciate your help.
Unfortunately, it doesn't work for me as my data for Over/Under Reported time column is presented as a daily period (probably I forgot to mention that). And then I use a measure to sum Over/Under Reported time by month using this formula:
Anyway, in order to create a slicer I need a column and it is also impossible to create a column in direct quiery based on this measure.
I also tried to create a custom column in Query Editor by your example but due to those limitations, my formula doesn't work .
Thank you,
Best Regards
Mary
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |