Forum Discussion
Advocate IPrevious Date Measure for a New Card Visual
Super UserHi mikebrodt
Very tough without a model or data but I noticed one thing.
In your [Previous Corporate IT Billable Datacenter Host Licenses] measure, have you tried changing <> MAX( to < MAX( ?
Advocate IThanks for the suggestion! I tried, but I am still having the same issue. As for the model, it is really just the Servers table connected to a Data table. It is a One-to-Many relationship.
- gmsamborn
Hi mikebrodt
Is there any way you can come up with sample data and your expected result based on the sample data?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I hope this helps.
Also, please add @gmsamborn to your reply or I might miss it.
- mikebrodt
I think I figure dout what I need to do... I was able to replicate the way I want this to work by adjusting the measure to filter the date by the Date Dimension table instead of the date column in the fact table. Then it worked. Let me put together a sampel to upload with examples of it set up both ways for experimentation and to valida what I am seeing is the way it should work.