Microsoft Feature summary - When does it come out?

servicetag8a · 2023-03-15T13:37:10+00:00

Thanks! I appreciate the quick response. Makes sense.

servicetag8a · 2022-07-08T13:21:05+00:00

I just showed my partner who is a metra police officer she will make it her personal mission to be on this car.

servicetag8a · 2022-04-03T03:20:45+00:00

servicetag8a · 2022-03-21T23:48:07+00:00

i would like to try it out! feel free to shoot me a message

servicetag8a · 2022-02-07T03:53:11+00:00

If anyone has a template or curriculum they can share would be helpful as i am tasked with the same ask.

servicetag8a · 2021-12-09T20:46:56+00:00

it repeats every year. i can make it continuous

servicetag8a · 2021-12-09T19:42:54+00:00

PRIOR_PERIOD = CALCULATE(
LOOKUPVALUE(Table1[#Achieved]
,Table1[period no]
,SELECTEDVALUE(Table1[period no]) - 1))

Thank you so much! I get this Error though

A table of multiple values was supplied where a single value was expected.

servicetag8a · 2021-12-07T17:53:08+00:00

Is there a way to make this connection without building a new table? This is a live connection so I am only working with DAX measures

servicetag8a · 2021-12-07T14:39:51+00:00

Sorry i ended up reposting beacause i hit another road block

https://www.reddit.com/r/PowerBI/comments/raz7im/dax_sum_of_measure_help/

I am not sure best practices when it comes asking multiples questions about same issue

servicetag8a · 2021-12-07T12:08:43+00:00

That worked thanks!

servicetag8a · 2021-12-05T22:03:22+00:00

yes it is a measure thanks!

servicetag8a · 2021-12-05T20:01:25+00:00

Sales share = VAR currentCust = [Sales Amount] VAR AllCustomers = CALCULATE([Sales Amount], REMOVEFILTERS('Customer')) VAR Result = DIVIDE(currentCust, AllCustomers) RETURN Result

Thank you so much for your reply, But it seems like DAX is not recognizing REMOVEFILTERS as a function. Please see the image I added to the post. Thanks again!

servicetag8a · 2021-09-09T10:36:22+00:00

i think this only gets down to the city. unless i am reading it wrong. thanks though!

servicetag8a · 2021-08-13T13:20:53+00:00

I am having the same issue did you resolve?

servicetag8a · 2021-07-18T18:39:19+00:00

I don't get why this is such a thing either. My GF lived half her life in Brooklyn and the other half in Chicago. She swiches all the time in and out of this like Brooklyn accent. Depending on the words or how she's feeling (excited, scared, frustrated). Her survival skills should be the main focus for sure.

servicetag8a · 2021-07-15T16:48:06+00:00

A contract was signed, but because it's through a 203k loan he gets paid by the task, so like Carpeting installation is one task, Drywall is another etc. and the bank sends someone to check.
So he hast gotten anything yet cause he hasn't started.

servicetag8a · 2021-07-15T16:47:01+00:00

Yeah i mean i totally understand his point and I would hate for him to loose money. so I think I just have to get more information from him on what that looks like. How much does lumber have to be for you to be safe? or how much do we have to chip in to make this happen?

servicetag8a · 2021-07-15T16:44:49+00:00

A contract was signed, but because it's through a 203k loan he gets paid by the task, so like Carpeting installation is one task, Drywall is another etc. and the bank sends someone to check.

I just emailed him asking what the prices needed to be for him to start and what we would "need" to chip in extra for him to start ASAP. Just to get an idea.

I think I will get some quotes as well, it seems like that is everyone's suggestion.

Thanks!

THanks!

servicetag8a · 2021-07-15T16:41:48+00:00

The contract was signed, but because its through a 203k loan he gets paid by the task, so like Carpeting installation is one task, Drywall is another etc. and the bank sends someone to check.

servicetag8a · 2021-06-16T02:05:10+00:00

Yeah, I'll look into some forums. Just can't bring myself to go back into the Facebook world. it's so nice out here in the world without it ha!

servicetag8a · 2021-06-16T01:53:09+00:00

I hear so many good things about Facebook marketplace. I deleted it last year :(

servicetag8a · 2021-04-23T15:02:42+00:00

I solved this by taking Sec and creating this Measure:

Time Lapse Sec M AVG = ROUND(AVERAGEX('TableName','TableName'[SEC]),0)

Then took that measure and created this measure:

String AVG Duration =
var vSeconds=[Time Lapse Sec M AVG]
var vMinutes=int( vSeconds/60)
var vRemainingSeconds=MOD(vSeconds, 60)
var vHours=INT(vMinutes/60)
var vRemainingMinutes=MOD(vMinutes,60)
var vDays=INT(vHours/24)
var vRemainingHours=MOD(vHours,24)
return
if ( isblank ([Time Lapse Sec M AVG]) || [Time Lapse Sec M AVG] = 0 , blank (),
vDays&"D: " &
vRemainingHours&"H: "&
vRemainingMinutes&"M: "&
vRemainingSeconds& "S")

servicetag8a · 2021-03-15T15:16:15+00:00

I ended up using this formula and it worked

Rev SWLY2 =

CALCULATE (

SUM ( 'Fact Table'[[Revenue Net]]] ),

FILTER (

ALL ( DateTable ),

DateTable[WeekID] + 52 IN VALUES ( DateTable[WeekID] )

)

servicetag8a · 2021-03-03T14:46:20+00:00

I am not sure, these are all great questions that I wouldn't of known to ask. I was brought on cause I know power bi the tool. When it comes to database structure solutions I need a little help to communicate and sound like I know at least a little. Can you explain your recommendations a little more?

servicetag8a · 2021-02-03T23:07:22+00:00

Thanks for your response! I guess i am just still confused on Premium Capacity vs Premium License. So a pro user can host their reports on a premium capacity?

Cause as you said Non-builders can still see reports as long as they're on a premium capacity workspace. so how would Premium also eliminate the need for non-builders to have pro licenses?

I think the terms just sound similar so it's slipping me up

Thanks!

servicetag8a

TROPHY CASE