filter values for certain years PowerBI Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!What is the best way to filter a Java Collection?list comprehension vs. lambda + filterPowerBI: Date and Date time Filter Using URL Parameter in reportDynamic Filtering at PowerBI Report levelPower BI Count not working correctly for SamePeriodLastYear with slicerPowerBI / PowerQuery: Date slicer for multiple tablesPowerBI: How to display/filter row tables between 2 years dynamicallyAdd parameter to Highest and Lowest value in Matrix and Year formatHow to make chart ignore filter in matrix headers?Calculated Column - Filtering MAX on date range from filter
Denied boarding although I have proper visa and documentation. To whom should I make a complaint?
Does classifying an integer as a discrete log require it be part of a multiplicative group?
Most bit efficient text communication method?
How to find all the available tools in mac terminal?
Do I really need to have a message in a novel to appeal to readers?
How to convince students of the implication truth values?
Is the Standard Deduction better than Itemized when both are the same amount?
When the Haste spell ends on a creature, do attackers have advantage against that creature?
Can an alien society believe that their star system is the universe?
Around usage results
Extracting terms with certain heads in a function
Why didn't Eitri join the fight?
Can anything be seen from the center of the Boötes void? How dark would it be?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
How could we fake a moon landing now?
How come Sam didn't become Lord of Horn Hill?
How would a mousetrap for use in space work?
What is the longest distance a player character can jump in one leap?
Using audio cues to encourage good posture
Is it a good idea to use CNN to classify 1D signal?
How do I stop a creek from eroding my steep embankment?
Why are the trig functions versine, haversine, exsecant, etc, rarely used in modern mathematics?
Wu formula for manifolds with boundary
Trademark violation for app?
filter values for certain years PowerBI
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!What is the best way to filter a Java Collection?list comprehension vs. lambda + filterPowerBI: Date and Date time Filter Using URL Parameter in reportDynamic Filtering at PowerBI Report levelPower BI Count not working correctly for SamePeriodLastYear with slicerPowerBI / PowerQuery: Date slicer for multiple tablesPowerBI: How to display/filter row tables between 2 years dynamicallyAdd parameter to Highest and Lowest value in Matrix and Year formatHow to make chart ignore filter in matrix headers?Calculated Column - Filtering MAX on date range from filter
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I need to filter certain user_name values for 2018 year in powerBI matrix, but different for year 2019.
Is it possible please?
Filter same values for all the years is easy, many options, slicer, filter in table, but I didn`t manage how to achieve different values for different year :(
Could you please help?
Edit:
I am trying to filter using query editor:
let Source = Oracle.Database("xxx", [HierarchicalNavigation=true]), TIMESHEET_HRIS = Source[Schema="TIMESHEET_HRIS"][Data], TIMEFACTSDAY1 = TIMESHEET_HRIS[Name="TIMEFACTSDAY"][Data], #"Filtered Rows" = Table.SelectRows(TIMEFACTSDAY1, each not List.Contains(129,1142,[USER_ID]) or [DAY] <= #date(2018, 1, 1)) in #"Filtered Rows"`
Nevertheless, I am getting following error:
[Expression.Error] We cannot apply operator < to types Date and DateTime. How to solve this problem please?
Thanks
filter powerbi
asked Mar 8 at 18:46
bennesbennes
2128
add a comment |
I need to filter certain user_name values for 2018 year in powerBI matrix, but different for year 2019.
Is it possible please?
Filter same values for all the years is easy, many options, slicer, filter in table, but I didn`t manage how to achieve different values for different year :(
Could you please help?
Edit:
I am trying to filter using query editor:
let Source = Oracle.Database("xxx", [HierarchicalNavigation=true]), TIMESHEET_HRIS = Source[Schema="TIMESHEET_HRIS"][Data], TIMEFACTSDAY1 = TIMESHEET_HRIS[Name="TIMEFACTSDAY"][Data], #"Filtered Rows" = Table.SelectRows(TIMEFACTSDAY1, each not List.Contains(129,1142,[USER_ID]) or [DAY] <= #date(2018, 1, 1)) in #"Filtered Rows"`
Nevertheless, I am getting following error:
[Expression.Error] We cannot apply operator < to types Date and DateTime. How to solve this problem please?
Thanks
filter powerbi
asked Mar 8 at 18:46
bennesbennes
2128
*put to original question
– bennes
Mar 9 at 6:47
add a comment |
I need to filter certain user_name values for 2018 year in powerBI matrix, but different for year 2019.
Is it possible please?
Filter same values for all the years is easy, many options, slicer, filter in table, but I didn`t manage how to achieve different values for different year :(
Could you please help?
Edit:
I am trying to filter using query editor:
let Source = Oracle.Database("xxx", [HierarchicalNavigation=true]), TIMESHEET_HRIS = Source[Schema="TIMESHEET_HRIS"][Data], TIMEFACTSDAY1 = TIMESHEET_HRIS[Name="TIMEFACTSDAY"][Data], #"Filtered Rows" = Table.SelectRows(TIMEFACTSDAY1, each not List.Contains(129,1142,[USER_ID]) or [DAY] <= #date(2018, 1, 1)) in #"Filtered Rows"`
Nevertheless, I am getting following error:
[Expression.Error] We cannot apply operator < to types Date and DateTime. How to solve this problem please?
Thanks
filter powerbi
asked Mar 8 at 18:46
bennesbennes
2128
I need to filter certain user_name values for 2018 year in powerBI matrix, but different for year 2019.
Is it possible please?
Filter same values for all the years is easy, many options, slicer, filter in table, but I didn`t manage how to achieve different values for different year :(
Could you please help?
Edit:
I am trying to filter using query editor:
let Source = Oracle.Database("xxx", [HierarchicalNavigation=true]), TIMESHEET_HRIS = Source[Schema="TIMESHEET_HRIS"][Data], TIMEFACTSDAY1 = TIMESHEET_HRIS[Name="TIMEFACTSDAY"][Data], #"Filtered Rows" = Table.SelectRows(TIMEFACTSDAY1, each not List.Contains(129,1142,[USER_ID]) or [DAY] <= #date(2018, 1, 1)) in #"Filtered Rows"`
Nevertheless, I am getting following error:
[Expression.Error] We cannot apply operator < to types Date and DateTime. How to solve this problem please?
Thanks
filter powerbi
filter powerbi
asked Mar 8 at 18:46
bennesbennes
2128
asked Mar 8 at 18:46
bennesbennes
2128
edited Mar 9 at 6:49
bennes
asked Mar 8 at 18:46
bennesbennes
2128
asked Mar 8 at 18:46
bennesbennes
2128
asked Mar 8 at 18:46
bennesbennes
2128
2128
*put to original question
– bennes
Mar 9 at 6:47
add a comment |
*put to original question
– bennes
Mar 9 at 6:47
*put to original question
– bennes
Mar 9 at 6:47
*put to original question
– bennes
Mar 9 at 6:47
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069235%2ffilter-values-for-certain-years-powerbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069235%2ffilter-values-for-certain-years-powerbi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
*put to original question
– bennes
Mar 9 at 6:47