Strange Issue - My Date table is showing the same ...

minimalist

Sorry if this is in the wrong place but I don't know my way around.

Look at this matrix, specifically the Date field.

As you can see, every row is showing the same date but despite appearances, it is filtering the Order table correctly.

I only noticed this a few hours ago and I can't figure out what is going on. I don't use the daily date field in many visuals so don't know when this first started happening.

My model has only one date table and it is marked as a date table. This visual above is only using one simple SUM() aggregation. The two other date fields shown are coming from the same Date table.

This is what my Date table looks like. Everything looks as it should in the Lakehouse. The Date table created in my Dataflow is from 01/01/2018 to 31/12/2025.

Any thoughts?

maruthisp

Hi @minimalist,

Can you try below DAX expression as per the original post description:
VAR Date_PreviousMonth = EOMONTH(EDATE(SELECTEDVALUE('POC Data'[MonthEndDate]), -1), 0)
VAR Backlog_PreviousMonth =
CALCULATE(
SUM('POC Data'[IFRS Backlog]),
ALL('POC Data'[MonthEndDate]),
'POC Data'[MonthEndDate] = Date_PreviousMonth
)
RETURN
Backlog_PreviousMonth

Please let me know if you have any comments. Thanks.
Best Regards,
Maruthi

minimalist

Hi Maruthi,

Thank you for the reply but I don't see how I can use this measure with my model.

Your measure only refers to one table and my issue is related to how the Dates column of my date table (that the relationships are based on) is showing incorrectly when filtering my Orders table.

Despite the data appearing incorrectly, the correct filter context is being applied and the result in the visual is showing the the correct value (for the date that is not shown)