python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - powerbi

How to loop through values in a column in DAX

I have a table that looks like this: Document PartNum Cost A 1 5 A 1 5 A 2 3 A 2 3 B 1 1 B 1 1 B 3 ...
test-img

Conner

powerbi

dax

Votes: 0

Answers: 1

Latest Answer

I have a solution using MQuery & DAX. #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"PartNum", type text}}), #"Added Custom" = Table.Ad...
test-img

Kunwar Maurya

Power BI Embedded on LOCALHOST

I know that one of the major steps in power bi embedded is to give your app permission to it (I have an existing app in azure ad) but what if I'm just trying to get it working on localhost! Here's my ...
test-img

Lizi

powerbi

powerbi-embedded

Votes: 0

Answers: 1

Latest Answer

It seems like you are using the wrong tokenType You need to use tokenType: models.TokenType.Aad For more information regarding tokenType, you can check this documentation: https://learn.microsoft.com/...
test-img

Rahul Roy

Create new table using last row of other table in power BI

I have following table AllIterationTable AreaPath IterationPath StartDate EndDate power power - Sprint1 08-03-2021 00:00 13-03-2021 00:00 power power - Sprint 3 15-03-2021 00:00 20-03-2021...
test-img

Shri Samarth

powerbi

dax

powerbi-desktop

powerbi-datasource

Votes: 0

Answers: 1

Latest Answer

Try the calculated table as follows: MyTable= VAR maxDate = CALCULATE( MAX( AllIterationTable[StartDate] ), ALL( AllIterationTable ) ) VAR result = FILTER( AllIterationTable, AllIterationTable...
test-img

intruderr

Combine two formulas in power query

Need to generate the end date based on Vesting type column I am able to generate formulas to create the end date as per the below column I have been able to generate the formulas in power query in t...
test-img

user17295743

excel

powerbi

powerquery

Votes: 0

Answers: 1

Latest Answer

You could use below code. Change column names as needed to include the line feeds let StDt = [Grant date], end = [Vesting end date], vType = [Vesting tenure], vType2 = [Vesting type], Enddate = [End ...
test-img

horseyride

Posts

Questions

Blogs

Jobs