Forum Discussion
Date Filter
You need to use a disconnected calendar table.
Hi,
I have a pbix and excel data sample link here. So I have already set the date filter in power query to get the numbers for December 2023. I get the numbers by totalling up [Duration New].
Next is I want to do this same date filter conditions for other months. For example November 2023.
Start dates will be all dates pre 30 November 2023 will be selected. Anything after will be unchecked.
End dates will be all dates post 1 November 2023 will be selected. Anything before will be unchecked.
Problem No.2 is how to visualise this?
For example, in the visuals it is showing 135k for December 2023. But the actual numbers for December 2023 is actually around 1602540. I don't want this number to be spread out through the months.
I know it is abit confusing but appreaciate any help. Thanks.
Cheers
Darren
For example, in the visuals it is showing 135k for December 2023
135k what? hours inside contracts?
Here's a first stab, shown by contract start date. This can then be extended over the contract duration once I know what you are calculating.
135k is actually minutes. i am calculating content hours. i do have a simple measure to calculate the hours.
Content Hours = SUM('SVOD Data'[Duration New])/60
appreciate your help. 🙏I think the calculation will be quite complicated...any help it is appreciated. The numbers for December 2023 should be 1602540 instead of 135k. It is being spread out throughout the months and years.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.