Forum Discussion
Date Table Not Working
Hello, I started using PowerBI desktop a couple of months ago. It is set up for direct query and I have an appended query with a date which is single direction related to a Date Table. It will not ...
It is a date column in a date table I created that runs for several years starting with 1/1/2022.
I have a table with sales from 1/1/2022-8/31/2023, I update it monthly. I am trying to do a matrix visual that shows various time intelligent totals such as rolling 12 months sales, prior YTD and a variance of prior YTD vs Current YTD ultimately. I have started with Prior YTD and it gives me the below in the visual which is the entire prior year (2022), expecting 1/1/2022-8/31/2022 as that is the latest date in the HS Sales Date column of the 2022-2023 Health Systems table I had in my original post (which is the column I have related to the Day in the Date Table).
YTD Sales Formula as I originally did it:
Prior YTD: