DAX and Transform questions
Ask the community and the AI Insights 365 team. Search first: your answer may already be here.
-
0votes1answer32viewsWhy does Transform preview only show some rows?
The preview stops at a few hundred rows. Does the step still apply to all rows?
-
0votes0answers26viewsCan I see the SQL that a chart runs?
For auditing, can I see the query behind a chart?
-
0votes0answers25viewsHow do I write a running total measure?
I need a cumulative sales line over the year.
-
0votes0answers24viewsCan a measure reference another measure?
I want Profit % to use my existing Total Profit measure. Is that allowed?
-
0votes1answer31viewsCan I split one column into two?
I have 'City, Country' in one column and want them separate.
-
0votes1answer31viewsHow do I change a column's data type in Transform?
A date column is coming through as text. How do I convert it?
-
0votes1answer29viewsWhere is the cheat sheet of common formulas?
Is there a quick reference of the most useful formulas?
-
0votes1answer32viewsCan I use time intelligence like year-to-date?
Finance wants YTD and same period last year. Are those available?
-
0votes1answer28viewsWhy does my measure return blank?
My measure shows blank on some rows instead of a number.
-
0votes1answer29viewsCan I build an ETL pipeline that feeds a tabular model?
We want a repeatable pipeline from raw data to a modelled dataset. Is that supported?
-
0votes1answer35viewsWhat is a semantic model and why does it matter?
The blog talks about semantic models. Do I need one?
-
0votes1answer34viewsHow do I combine two SQL tables into one?
I want Sales joined with Countries so I get Sales by Region.
-
0votes1answer30viewsHow do I remove duplicate rows?
My upload has duplicated lines. How do I clean them up?
-
0votes1answer30viewsWhy are Round and Abs disabled in Transform?
In the Number tab, Round and Abs are greyed out. How do I enable them?
-
0votes1answer34viewsCan I undo a step in Transform?
I applied the wrong filter in the Transform Workbench. How do I go back?
-
0votes1answer32viewsWhat is the Transform Workbench?
I see a Transform step in my workspace lineage. What can I do there?
-
0votes1answer34viewsWhich DAX functions are supported?
Before I port our Power BI measures, which functions work here?
-
0votes1answer33viewsHow do I create a calculated column with IF?
I want a 'Margin band' column: High, Low or Loss depending on profit.
-
0votes1answer30viewsCan I test a DAX measure before saving it?
I don't want to break the report with a wrong formula. Is there a preview?
-
0votes1answer33viewsHow do I use CALCULATE to filter a measure?
I want total sales for the Government segment only, as a measure.