Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have literally been trying to figure this out for the past 4 hours. I have tried using variables, Previousday, intervals, etc.
No matter what I do I literally can not seem to select a single cell from yesterday's date. I need to create a measure beacuse I have to use that number to do further calculations. It should not be this difficult =[
I have a table that already aggregates total users and updates daily. Just need a measure to select this value. I have a date table.
So I just realized that in Edit Query mode it is actually perfect, but in the modeling view that I showed you it seems to be skipping dates. When I hit the filter on "date" column in modeling mode I can see every single day in order so it is definitely a sort by column issue. Is that bad?
Nope, the way you have the table sorted in the data view won't do anything to calculations using the table.
CALCULATE(SUM('LogTable'[RunStatus]),'LogTable'[Date]=Date(YEAR(now()),Month(now()),(DAY(now())-1)))
If I used my date table here why would that not work than? Isn't it just saying the same thing as using the tables date? I don't get it
CALCULATE(SUM('LogTable'[RunStatus]),'LogTable'[Date]=Date(YEAR(now()),Month(now()),(DAY(now())-1)))
--This part sums your values
CALCULATE(SUM('LogTable'[RunStatus]),
--This part checks for your dates in the table. Should also work with date table. Perhaps if you try using Related()
'LogTable'[Date]=
--This part sets yesterdays date.
Date(YEAR(now()),Month(now()),(DAY(now())-1)))
Hope that helps.
I noticed that as well, but it is because I organize by MonthNum. If I don't do that the numbers are messed up on a line graph. I don't think that is the issue? The order of the column itself should not matter if all the dates are there and they are organized accordingly? That is just how the data is stored?
Could you post your Measure?
No just returns blank... Let me see if I can't just create an imgur album and add a ton of pictures of my data
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |