Forum Discussion
No Time Intelligence Functionality
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?
4 Replies
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/434008Otherwise, 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.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?
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.
Hi learning_dax
What is the code for [StartCount]? Can you share a sample file?
