Forum Discussion
Anonymous
6 years agoNot applicable
MAX function with Text column doesn't work in Live Connection SSAS Tabular
Hi Experts, I have a trouble using DAX function: MAX. I want to get a unique value from Text column to use switch to use different calculation for each category in one measure. In Power BI D...
Greg_Deckler
6 years agoCommunity Champion
Perhaps LASTNONBLANK ?
That's good to know about the MAX function because I use it all the time with text columns.
Anonymous
6 years agoNot applicable
Thanks Greg,
Have you usually used MAX function in Power BI like in my situation as well?
Did you try the same function in SSAS Tabular(SSDT) to make measure in it?
When Power BI is connected with SSAS Tabular is the same, it doesn't work MAX function even I make report level measure in Power BI.