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

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi Anonymous ,

 

I hope the information provided has been useful. Please let me know if you need further clarification

 

Thank you.

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi  Anonymous,

 

Just wanted to check if you had the opportunity to review the suggestion provided?

 

Thank you.

  • v-tejrama's avatar
    v-tejrama
    Community Support
    1 year ago

    Hi Anonymous ,

     

    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

     

    Thank you.