Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
Is there a function that can help to copy a table and then filter based on a specific value from one column without doing it from the Edit Query side?
Thank you!
Solved! Go to Solution.
Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:
Table 1 = FILTER('Table',[Column] = "Value")
You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]
Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:
Table 1 = FILTER('Table',[Column] = "Value")
You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]
Hi i am looking for some help, if i wanted the value to be a range (last 31 days) from a date column do you knwo how i can do this in power BI DAX?
I can get it to work to pull oly todays date, but want it to dynamically create a table with the last 31 days from a larger table.
Table = FILTER('Safety Score table', 'Safety Score table'[Date] = TODAY())
Thanks in advance
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |