Forum Discussion
Same measure
[Using a direct query]
Hi,
I have the following table
with the following measure:
Solved, established a relationship between Date in the Rolling Calendar table and timestamp in the Moves table.
6 Replies
- Syk
Resident Rockstar
What are you trying to get?
Effectively what I am after is Moves broken down by month so I can use a KPI on the current and previous month. I think I have gone down this route based on an example but there must have been other factors in play.
Thank you for your continued help
As the initial table is time based, I expected filtering by month would provide monthly totals, is this not correct?
- Syk
Right now, you're just counting your timestamp column.
The example I was referencing was
Where the revenue was
Total Revenue =SUMX('Sales Data','Sales Data'[OrderQuantity]*RELATED('Product Lookup'[ProductPrice]))and the month element was
If I switched to COUNTX would that give the the monthly grouping of moves or do I need to build a query to get this?Solved, established a relationship between Date in the Rolling Calendar table and timestamp in the Moves table.
