Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |