Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Tableau Function to Power BI

I'm needing to migrate this Tableau code to Power BI and have had no luck doing so. IF [Frequency]='Monthly' THEN { FIXED [Work Item ID],[Savings],[Frequency] : AVG(DATEDIFF('month',[Closed...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Hi Anonymous try the below measure and let me know if it helps.

     

    MonthlyAvgAmountMeasure =
    VAR FilteredTable =
    FILTER (
    ALL ( 'Table' ),
    'Table'[Frequency] = "Monthly"
    && NOT ISBLANK ( 'Table'[Closed Date] )
    )
    RETURN
    AVERAGEX (
    SUMMARIZE (
    FilteredTable,
    'Table'[Work Item ID],
    'Table'[Savings],
    'Table'[Frequency],
    "CalcVal", DATEDIFF ( 'Table'[Closed Date], TODAY(), MONTH ) * 'Table'[Amount]
    ),
    [CalcVal]
    )

Jai-Rathinavel's avatar
Jai-Rathinavel
Super User
1 year ago

Hi Anonymous try the below measure and let me know if it helps.

 

MonthlyAvgAmountMeasure =
VAR FilteredTable =
FILTER (
ALL ( 'Table' ),
'Table'[Frequency] = "Monthly"
&& NOT ISBLANK ( 'Table'[Closed Date] )
)
RETURN
AVERAGEX (
SUMMARIZE (
FilteredTable,
'Table'[Work Item ID],
'Table'[Savings],
'Table'[Frequency],
"CalcVal", DATEDIFF ( 'Table'[Closed Date], TODAY(), MONTH ) * 'Table'[Amount]
),
[CalcVal]
)