dax table
5 TopicsCalculate table: Last record of day for that subscription_id (Dax)
Hello there. I would like to use DAX to calculate a new table from the below - basically retaining all the yellow rows. The logic: For each subscription_id, keep its last record for the day (because that will tell me if it's currently on or off). I've been struggling with this for hours, I'd really appreciate your help. Input: this entire table Output (via calculated table): Only the yellow rows Logic: For each subscription_id, keep its last record for the daySolved1.1KViews0likes3Comments
Dax Calculated Table
I am trying to take the sample dataset: ID Location Number Bracket 123 North America $101-$250 233 North America $251-$500 433 EMEA $101-$250 697 APAC $501-$1000 And create a calculated table in DAX that performs the following: Index Bracket North America APAC EMEA 1 $101-$250 1 0 1 2 $251-$500 1 0 0 3 $501-$1000 0 1 0 Essentially creating a pivot table. Let me know if this is possible. Thank you!Solved929Views0likes1CommentCreate Table based on columns and measures
Community, I need a little help! Is there any way to create a table based on a column and a measure? Let me explain the case: I have a PRODUCTS table with a column called family_name. Each product has its own family. Ex: product family_name 1 AAA 2 AAB 3 AAC 4 AAD 5 AAE I have a measure that CALCULATE the Time to Win for each opportunitie on table OPPORTUNITIES. Ex: Time to Win (Family) = CALCULATE( AVERAGEX( SUMMARIZE( FILTER(fOportunities,fOportunities[statecode] = 1), fOportunities[opportunityid], dProducts[family_name], "AvgDays",MAX(fOportunities[DaystoClose]) ), [AvgDays] ), USERELATIONSHIP(dCalendar[ID Data],fOportunities[actualclosedate]) ) Now, I wloud like to generate a table like this: family_name Time to Win AAA 5 AAB 10 AAC 15 AAD 20 AAE 25 I have tried to aproach using SUMMARIZE, ADDCOLUMN but I couldn´t figure out how to do it. Any help?Solved1.7KViews0likes3Comments
Change formulas to point to another table - in bulk
I have a table that has about 100 DAX measures pointing to it. I recently had to change the scope of the source data so it was uploaded under a new table name. The fields in the original table also exist in the new table so I'd like to change the dax formulas to point to the new table. So, for example, I'd like to change this SUM('GSD DSR Summary Data'[% Call/Chat Abandon Rate]) to this SUM('GSD Data'[% Call/Chat Abandon Rate]) Is there a way to do this in bulk (all the formulas at once) or do I have to change each one individually?Solved598Views0likes2CommentsDAX query for Unique columns and Table creation
Hi, I am actually looking for a DAX query which can help me give a combination of unique values of two columns. Let me illustrate an example on the same. item no | description | amount 1 | good | 20 1 | good | 21 1 | bad | 30 2 | good | 50 I need the table that gives me the uniqe combination of item no and description. Like item no | description 1 | good 1 | bad 2 | good I have used the summarizecolumns but still it gives me certain duplicates. Can someone help me on the same?Solved1.6KViews0likes4Comments
