cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivath0
Frequent Visitor

Quick Measure Error Message

How do I correct this error?

 

OutFlow YTD =

IF(ISFILTERED('Cap'[ "Date"]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    TOTALYTD([OutFlow], 'Cap'[ "Date"].[Date])

1 ACCEPTED SOLUTION
parry2k
Super User III
Super User III

@ivath0 also if it still doesn't work, share PBIX with sample date thru one drive/google drive. Remove any sensitive information before sharing.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

9 REPLIES 9
parry2k
Super User III
Super User III

@ivath0 also if it still doesn't work, share PBIX with sample date thru one drive/google drive. Remove any sensitive information before sharing.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

parry2k
Super User III
Super User III

@ivath0 are you still getting the error with the code and in my blog post, it also mentioned that date table should be marked as a date table as mentioned by @PhilipTreacy . 

 

Also, did you changed the measure? It should use Date from new data table.

 

IF(ISFILTERED('Date Table'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    TOTALYTD([OutFlow], 'Date Table'[Date])

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





PhilipTreacy
Super User III
Super User III

Hi @ivath0 

Having created the Date Table you need to tell PBI to use it as the Date Table for the model/calculations.

In the Data view you should have a table like this

dt1.png

 

Right click on it and click Mark as date table -> Mark as date table

dt2.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


parry2k
Super User III
Super User III

@ivath0 can you please paste the code here...I don't which code you are trying or referring to?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





ivath0
Frequent Visitor

CalendarAuto code.PNG

 

parry2k
Super User III
Super User III

@ivath0 not sure which code your copied, can you share/provide more details.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





ivath0
Frequent Visitor

The code I'm trying is copied from your post, referred to in a previous reply

parry2k
Super User III
Super User III

@ivath0 you should add a date dimension in your model, check this post on how to add one.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 

 

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





ivath0
Frequent Visitor

I've copied your code but I get the following error message:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. What have i missed?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.