Tableau LOD & Power BI DAX
Tableau LOD to Power BI DAX?or Power BI DAX to Tableau LOD.
Tableau :
{FIXED :?MAX([Sales] )}
Power BI :
CALCULATE(MAX(‘Orders'[Sales]),ALL(‘Orders’))
Tableau:
{FIXED [Customer Name]: MAX(IF [Category]=”Tech” THEN [Ship Date] END )}
Power BI:
CALCULATE(max(Orders[Ship Date]) ,ALLEXCEPT(Orders,Orders[Customer Name]),Orders[Category] = “Tech”)