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.
Hi community,
I was given help months ago to come up with a script; it's been working wonderfully. I now need to expand it. This is how it looks currently:
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE ( 'CM360', 'CM360'[Date], 'CM360'[Placement ID] ),
"Cost-per-day",
CALCULATE( SUM(('CM360'[impressions])) / 1000) * 4
),
'CM360'[site_cm360] = "Programmatic Ads"
)
---------------------------------------------------------------------------------------------------------------------------------
You can see we've created a calculated table where we've taken the [Date] and [Placement ID] columns from an existing table, 'CM360'. We've then created another column, "Cost-per-day", calculated by taking [impressions], dividing that by 1000, then multiplying by 4 dollars. Only where the column, 'CM360'[site_cm360], contains "Programmatic Ads".
I would now like to expand that script to something like this:
CALCULATETABLE (
ADDCOLUMNS (
FILTER ( 'CM360', (CONTAINSSTRING('CM360' ['Placement'], “banner”)), 'CM360'[Date] >= 01/09/2022 ),
SUMMARIZE ( 'CM360', 'CM360'[Date], 'CM360'[Placement ID] ),
"Cost-per-day",
CALCULATE( SUM(('CM360'[impressions])) / 1000) * 5.00
),
'CM360'[site_cm360] = "Programmatic Ads" OR “iAgency”
)
I wish to filter what we were doing before to rows where 'CM360' ['Placement'] column contains the string "banner".
And only where those rows have the date on or after September 1st 2022.
Additionally, in that last line, I wish to expand it so it now looks for those two different values in the column, 'CM360'[site_cm360]
Please can you look at my expanded script and help me understand how you would write it because I don't think this is how it should be written in DAX.
thank-you 🙂
Solved! Go to Solution.
hi @Pablo_Aimar
try like:
thanks again @FreemanZ I was able to take your code, modify and expand on it, then incorportate it into my larger script. It works now, and I'm very grateful for all the help 🙂
thank-you @FreemanZ
I inserted your block of code into my script:
PowerBI gives an error message, "Cannot find 'Table' " "Parameter is not the correct type". This is my full script:
I've tried various edits, including adding more parenthesis, but I just can't get Power BI to accept & execute this script. Any suggestions would be much appreciated 🙂
Pablo
hi @Pablo_Aimar
try like:
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |