Forum Discussion
Tableau to power bi
I need help with this cod from tableay to power BI
Fixed[Company Name], [Case Type] : AVG(datediff(day,[ Date case was Open],Today()))
I try to fiend how many days case was open
Thank you
Anonymous Easier with source data and expected output. My Tableau is only so so. Try:
Measure = VAR __Table = ADDCOLUMNS('Table',"__Days", ( TODAY() - [Date case was Open] ) * 1. RETURN AVERAGEX(SUMMARIZE(__Table,[Company Name],[Case Type],"__Avg",AVERAGE([__Days])),[__Avg])
1 Reply
- Greg_Deckler
Community Champion
Anonymous Easier with source data and expected output. My Tableau is only so so. Try:
Measure = VAR __Table = ADDCOLUMNS('Table',"__Days", ( TODAY() - [Date case was Open] ) * 1. RETURN AVERAGEX(SUMMARIZE(__Table,[Company Name],[Case Type],"__Avg",AVERAGE([__Days])),[__Avg])