Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have a Table that contains 2 columns that i want to create a new table from
1 of those columns is date / time of and the other column contains a 4 letter value
I would like to make a new table with specific 4 letter value and aslo the column that contains date/time
How could i do this from a Dax expression ?
Thanks
Solved! Go to Solution.
Hi @bcampbell
You can simply create a new table with this code:
NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")
where "ABCD" is the specific 4-letter value you want to keep.
Hi @bcampbell
You can simply create a new table with this code:
NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")
where "ABCD" is the specific 4-letter value you want to keep.
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 88 | |
| 49 | |
| 37 | |
| 31 | |
| 30 |