Forum Discussion
function used in this expression is not a valid function nor the name of a measure.
Hello.
I have the following DAX and receive this error : The function used in this expression is not a valid function nor the name of a measure.
Can anyone please help? I've blanked out certain names for privacy.
Name of Measure =
Name of VAR =
SUMMARIZE (
CALCULATETABLE('Table name', not(ISBLANK('Table name'[created_date]))),
[ID],
[created_date],
'Table Name'[Column Name],
"Column Name", IF('Table Name'[Column Name] ="Area", 'Table Name'[created_date]+0, Table Name(2)'[created_date]+1)
Hi Pricey79 ,
This formula is a bit confusing. Could you please provide some sample data without privacy information and more details about your desired output?
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Pricey79 ,
This formula is a bit confusing. Could you please provide some sample data without privacy information and more details about your desired output?
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you for your reply
Its supposed to create a table with the columns Column Name, and then add the +number of days from date created.
What else would you need to see please?
Thank you for your time, its much appreciated
