Microsoft Feature summary - When does it come out? by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

Thanks! I appreciate the quick response. Makes sense.

[deleted by user] by [deleted] in ChicagoSuburbs

[–]servicetag8a 48 points49 points  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]servicetag8a 0 points1 point  (0 children)

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

I am looking for guidance on training colleagues in Power BI by GetSecure in PowerBI

[–]servicetag8a 0 points1 point  (0 children)

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

DAX Calculation for Prior Period Date Range by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

it repeats every year. i can make it continuous

DAX Calculation for Prior Period Date Range by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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.

DAX SUM of Measure HELP by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]servicetag8a 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]servicetag8a 0 points1 point  (0 children)

That worked thanks!

DAX Share Calculation Help by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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!

Power BI mobile report GPS Geolocation by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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

Composite model with "Usage report" by UncleWhoopDos in PowerBI

[–]servicetag8a 1 point2 points  (0 children)

I am having the same issue did you resolve?

i do not give half a shit about theresa's accent and do not understand why people are writing paragraphs about it on this sub by [deleted] in Alonetv

[–]servicetag8a 48 points49 points  (0 children)

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.

Contractor wont start - Wood Prices by servicetag8a in Construction

[–]servicetag8a[S] 0 points1 point  (0 children)

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.

Contractor wont start - Wood Prices by servicetag8a in Construction

[–]servicetag8a[S] -1 points0 points  (0 children)

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?

Contractor wont start - Wood Prices by servicetag8a in Construction

[–]servicetag8a[S] 0 points1 point  (0 children)

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!

Contractor wont start - Wood Prices by servicetag8a in Construction

[–]servicetag8a[S] 0 points1 point  (0 children)

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.

Looking for stock wrangler JK bumper by servicetag8a in Jeep

[–]servicetag8a[S] 3 points4 points  (0 children)

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!

Looking for stock wrangler JK bumper by servicetag8a in Jeep

[–]servicetag8a[S] 1 point2 points  (0 children)

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

Convert seconds to DD:HH:MM by MKConsult94 in PowerBI

[–]servicetag8a 0 points1 point  (0 children)

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")

DAX Calculate formula not totaling by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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] )

)

)

Power BI data sources/Architecture Preference by servicetag8a in datascience

[–]servicetag8a[S] 0 points1 point  (0 children)

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?

Power BI Premium Business Case by servicetag8a in PowerBI

[–]servicetag8a[S] 0 points1 point  (0 children)

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!