topic Re: No Time Intelligence Functionality in DAX Commands and Tips

No Time Intelligence Functionality

learning_dax — Tue, 08 Feb 2022 09:37:38 GMT

Hi all,

I have a complicated/open-ended issue I can't seem to solve or debug. Mostly revolving around time intelligence functions being displayed as cards. As background information, I do have a separate date table connected to my dataset with both formats aligning, so I don't think its a formatting issues.

I've attached screenshots below. Every variation of these calculations I've tried as cards but I only get BLANK as a response. However, when i put them in tabular format they seem to work. Some of the functions in the left table include: TOTALYTD, ParallelPeriod, Dateadd (-1), & others. I only want them as cards because I'm trying to display YTD & MTD counts for my dataset as of a specific day of the month (for example if I refresh the dashboard on February 15, I want the counts as of that day when I refresh not just all of February because sometimes we have future data). The only way I have been able to do so (not with TOTALYTD/TOTALMTD because they give me blanks) is this formula which I scoured off of the web:

Calculate([StartCount],FILTER('Dimdate','Dimdate'[Date] >= DATE(YEAR(TODAY()),MONTH(TODAY()),01)),FILTER('DimDate','DimDate'[Date] < TODAY()))

And the above was only for MTD Counts I cannot seem to figure out YTD. I am relatively new to DAX and struggling to debuff this issue as time intelligence & card values are easiest for me to display. Any suggestions/help?

Re: No Time Intelligence Functionality

Greg_Deckler — Tue, 08 Feb 2022 09:59:08 GMT

learning_dax You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: No Time Intelligence Functionality

tamerj1 — Tue, 08 Feb 2022 11:46:44 GMT

Hi learning_dax
What is the code for [StartCount]? Can you share a sample file?

Re: No Time Intelligence Functionality

learning_dax — Tue, 08 Feb 2022 23:32:09 GMT

Hi Greg_Deckler ,

Thanks for the insights I've actually dove into many of your blogs since you shared this with me, specifically the *bleep* series for PARALLELPERIOD and DATEADD. However, all I am doing is simply replacing your 'Calendar' entry with my 'Date' entry and it says "the expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." I can attach a screenshot after this response. Any idea what might be happening?

Re: No Time Intelligence Functionality

Greg_Deckler — Wed, 09 Feb 2022 12:42:59 GMT

learning_dax If you can post sample data that would help tremendously in figuring out what is going on. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.