https://community.fabric.microsoft.com/t5/Developer/Date-Time-Difference/m-p/615719#M18472 <P>Hi All,</P><P>&nbsp;</P><P>I have a small requirement that i want to fulfill and i am&nbsp; new to Power Bi and Dax Queries.&nbsp;</P><P>&nbsp;</P><P>So currently i have a table which has three columns</P><OL><LI>Start Time</LI><LI>End Time</LI><LI>Employee ID</LI></OL><P>Now, what i want to do is to take out there Per Day/week/month consumption and show whether they are under-utilized or over-utilized.<BR /><BR />So basically, What i want to see on my report is when i filter out a user and his weekly consumption is less than&nbsp; 45, it should show me a card value saying Under-Utilized and if its total week consumption is above 45, it should show me over-utilized.<BR /><BR />Would really appreciate if i could get a quick reply.<BR />Thanks guys!</P> Mon, 04 Feb 2019 04:56:37 GMT Anonymous 2019-02-04T04:56:37Z https://community.fabric.microsoft.com/t5/Developer/Date-Time-Difference/m-p/615719#M18472 <P>Hi All,</P><P>&nbsp;</P><P>I have a small requirement that i want to fulfill and i am&nbsp; new to Power Bi and Dax Queries.&nbsp;</P><P>&nbsp;</P><P>So currently i have a table which has three columns</P><OL><LI>Start Time</LI><LI>End Time</LI><LI>Employee ID</LI></OL><P>Now, what i want to do is to take out there Per Day/week/month consumption and show whether they are under-utilized or over-utilized.<BR /><BR />So basically, What i want to see on my report is when i filter out a user and his weekly consumption is less than&nbsp; 45, it should show me a card value saying Under-Utilized and if its total week consumption is above 45, it should show me over-utilized.<BR /><BR />Would really appreciate if i could get a quick reply.<BR />Thanks guys!</P> Mon, 04 Feb 2019 04:56:37 GMT https://community.fabric.microsoft.com/t5/Developer/Date-Time-Difference/m-p/615719#M18472 Anonymous 2019-02-04T04:56:37Z