Time Intelligence Quick Measures Problem

Question

Hello everyone!&nbsp;I am new to Power BI, but desperately trying to figure it out.&nbsp;&nbsp;I have a problem with Time Intelligence Quick Measures.&nbsp;I have a set of data, which contains dates and prices for each date. The data type of the date column is "Date" as you can see below, formatted as a european date. Important: dates are not full, the ones with no price are excluded.&nbsp;&nbsp;When i try to make a quick measure "month-to-date-total" using my price (which is a decimal number type) as a base value and my date as a date, i get the following error in the code:&nbsp;"Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column"&nbsp;&nbsp;I also tried to work around it and made a separate column with a month number and tried to add a Quick measure " Average per category" using the month number as category, but then it always returns the count of instances and not the price average...&nbsp;thanks in advance!&nbsp;BRAnastasia&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Belinskaya00&nbsp;,&nbsp;You will need a Calendar Table.&nbsp;Check this link to create a Calendar Table&nbsp;https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/&nbsp;&nbsp;You can then create 2 measure .&nbsp;Total Sales = SUM(Table[Sales])&nbsp;Sales MTD = CALCULATE( [Total Sales], DATESMTD( Dates[Date] ) )&nbsp;Also suggest you see this videohttps://www.youtube.com/watch?v=U86045UGoW8&nbsp;&nbsp;Regards,Harsh NathaniAppreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!&nbsp;&nbsp;

Forum Discussion

Time Intelligence Quick Measures Problem

2 Replies

Related content

Measure formula problem

Dax measure for below problem

Logic problem?

Measure problem (problem with ALL)

Slider problems