Forum Discussion
Table calculation for Direct Query with historical data
I have two tables imported through Direct Query related by ID. Table 1 contains details such as Status (Red, Green) and the Date when they appear on that status (red time, green time). Table 2 h...
I'm going to try and show this as best I can through the reply function as I can't upload pbix or xlsx since I'm a new member:
TABLE 1
TABLE 2
What I would like to show is a table that shows in one visualization how many Red Id's/Serials are on a daily basis and how many Green Id's/Serials are, knowing that some Red Id's can turn green on the same day OR be resolved the following days:
The main issue here is that my data is through Direct Query and I saw that many DAX functions are not available so my data appears like this without summing the Id's:
Hope this better explains my inquiry!
Thank you!