Search results

In DAX calculated tables are only evaluated upon data load. And not when you make changes to slicer selection. If you need it to be interactive, you need significantly more complex set up. Or you can just use built-in filters to limit what's shown. As well, you need to replace ''[Client name]...

Are you doing this in Excel Data Model or is it in PowerBI Data model? If I recall Excel data model doesn't support calculated tables. I'd recommend doing most of the operation in PowerQuery stage. If using PowerBI, then you can simply do it like below. Table 2 = VAR _temp = SUMMARIZE (...

You are missing brackets for MIN and MAX. Dates Range = FORMAT(MIN('Semantic FactCommunications'[LetterSentDate]), "MM/DD/YYYY") & " to " & FORMAT(MAX('Semantic FactCommunications'[LetterSentDate]), "MM/DD/YYYY")

14. Various Table/List manipulation Recently had to build process to import customer generated PDF and transform it into format that can be imported into our project management software. While I can't share entire process, here are some useful operations to sanitize PDF. Check if a column in...

Don't ever filter DimDate table. Time intelligence will not behave correctly when full year dates are not in date dimension table(s). Always apply filter on Fact table. Do this in PQ using "= Date.From(DateTime.FixedLocalNow())" However, I can't really imagine fact table having future dates...

? If this is raw data. Then you just need to COUNTROWS().

I need to know what the underlying table looks like. Can you upload at least the raw data using Excel spreadsheet?

You need to provide sample data and what your visual shows. I don't know your data model structure and can't help with what info you provided.

SUMMARIZE requires that you supply following. SUMMARIZE(TableName, Column(s) to group by, "Aggregated column", calculation for aggregation) You don't have aggregate column in your SUMMARIZE.

Just stick it into card. No need to have it in the table.

Then you need to use SUMMARIZE() etc to give it same grain as the table visual. And count # of rows of the summarized table. You don't need all the calculated measures. Only sum() of some column to aggregate based on grouping utilized in your table visual. Ex: If table uses columns from...

Not quite sure what you need. In general you'd use COUNTROWS(). But it will really depend on your filter context and how your DAX measures are constructed. For an example, if you use CALCULATE(SUM(),FILTER(ALL(TABLE),Condition)) type construct, you'll need special handling that mirrors filter...

It's different. Power Query and other more advanced controls are only available on desktop. Though I have no idea about the content of what's covered in that class.

Please give sample that's representative of your actual need. Otherwise, we won't be able to help. I'd recommend uploading sample workbook, with manually crafted desired output.

You don't add the calculation as columns. But as measures. So it's evaluated according to context of visual or pivot table you use those measures in.

Depends on your data structure. Without knowing underlying table structure can't give you good answer. Having said that, here's general construct. Num = SUM(Table[Column]) Denom = SUM(Table[Column]) Percent = DIVIDE([Num],[Denom],Blank())

Upload sample file with your tables. Hard to help without it.

Simple method: Add "Flag" column: = if [Date]=Date.EndOfMonth([Date]) then true else false Filter for = true. Remove flag column. Sort ascending on Value. Group by Date, All rows. Keep last row of grouped column. Expand all but the Date column. Drop unnecessary columns and change data type...

Without sample hard to help. Escaping single quote in SQL statement is standard practice. See link. https://www.databasestar.com/sql-escape-single-quote/#:~:text=The%20simplest%20method%20to%20escape,Server%2C%20MySQL%2C%20and%20PostgreSQL.

Hmm, didn't work how? Did it give error message? DATEDIF has been in all Excel version since Excel 95 (though only documented for Excel 2000). See sample attached, side by side with mohamed's formula.

Are you using the name in the query? If so, you need to escape single quote by using 2 single quotes. Ex: '' instead of '

Try... In C5: Copy down. =IFERROR(DATEDIF(MAX($A$2,$A5),MIN($B$2,$B5),"d"),"")

Without knowing your data structure. We can't really help you. DAX is highly context dependent language and different evaluation context will give different result. I'd recommend uploading sample workbook with sanitized data, that's representative of your actual data structure. Along with...

That depends on your definition of contribution, and how it's being used. Contribution can certainly be positive or negative. Though, you didn't explain how each numbers contribute to total. So hard to give you answer. SUM of all value = 4.9 not 4.8. I'm assuming it's not sum of these numbers.

What you have is Snowflake schema. While it has its use. Should be avoided whenever possible to avoid downstream headache. Typically, you can create single calendar dimension table combining Year Helper, FY_Quarter_Helper. As well, you can probably pivot out Scn_Seasonality and Scn_Ramp and...