Forum Discussion
Possible Tip/Trick: Dynamic Date Dimension Table
I'm going to share the dynamic date dimension table I built, hopefully it is useful to someone! I named it DateTable for this tutorial, and my fact table FactTable. The table is built using the ...
It worked, I established the relation between the date column in date.dim table and the date column in my fact table. I modified the content on the date column in my fact table from "Month" "year" to 01.01.2016. I update the data type in PowerBI to (MMM yyyy)
Thank you for your help
Hi,
Now that I have this date table, I am having trouble actually using it. How can I calculate a rolling calculation, so that it will count the number of an event 60 days from today's date? Also, how to count the number of events in the future?