Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a new table of time intelligence calculations, but it does not seem to be working. I am using the SUMMARIZE function to groupby three different columns and perform the time intelligencence calculations.
If I try something like:
SUMMARIZE(
Table,
'Date'[Date], Table[Category], Table[Subcategory],
"Last Year", CALCULATE(COUNT('Table'[Subcategory]), DATEADD('Date'[Date], -1, YEAR))
)
The groupby works fine, but I do not return any values for my "Last Year" column - my result would look something like:
However, the same time intelligence calculation works perfectly fine as a measure.. just not in this context?
Additionally if I try another expression in place of the time intelligence calculation, I get the result I would expect.
For example, the following works perfectly fine with no blank values:
SUMMARIZE(
Table,
'Date'[Date], Table[Category], Table[Subcategory],
"Last Year", COUNT('Table'[Subcategory])
)
I'm not quite sure why this works, but the first one doesn't... especially when the same time intelligence expression works perfectly fine as a stand-alone measure.
Is there anything I can do to modify my expression to get this to work?
@markmess77 - Hmm, yeah, you stray outside the lines with the time "intelligence" functions and things start to break. 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-TIT...
@Greg_Deckler That's unfortunate. Wish that these time intelligence functions worked better lol
I had a second approach I had in mind to accomplish what I need. It's not as clean as what I'm trying here, but it should return the same thing.
I'll also give a deeper look into your links, seems interesting!
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |