Re: Strange Issue - My Date table is showing the s...

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?

v-agajavelly

Hi @minimalist

Thanks for the detailed explanation totally understand how confusing this can be, especially when the filters work but the Date column just repeats the same value. From what you described, this seems like a visual context issue the matrix is likely evaluating the Date field outside of its intended row context. To assist you effectively, could you please share sample data that fully illustrates your issue or question? We kindly request that the data be provided in a usable format (rather than as a screenshot) and if it does not contain any sensitive information or unrelated content.

Additionally, it would be helpful if you could include the expected outcome based on the sample data you provided.Thank you for your cooperation.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Regards,
Akhil

minimalist

Thank you for your response.

As I thought I posted this in the wrong place, I also posted the problem here:

https://community.fabric.microsoft.com/t5/Desktop/Strange-Issue-My-Date-table-is-showing-the-same-da...

I didn't mean to create an issue with duplication but I will try to maintain both threads. I don't believe there is any confusion in my model.

For testing, I deactivated all relationships and created an additional measure in my Dates table:

Date_Test = MAX(Dates[Date])

Then I created another visualisation using the Dates[Date] field and only this measure. I don't know how it is possible for the Date field to display the 14/03/2019.

What is even more unusual, if I reconnect the relationship between Orders and Dates, all other columns in my Dates table filter the Orders table, except the Dates[Date] field.

The result I expect is the Date column to show the Date that is in the table, not 14/03/2019.

As suggested, I attached sample data. This an extract from my Date table as it is too large to paste all of it.

Date	MonthYear	MonthYearSort	QtrYear	YearQtr	DayofWeek	DayOfWeekName	WeekofYear	YearWeek	Month Name	Year	MonthType	Month	YearType
01/01/2023	Jan-23	202301	Q1-2023	20231	6	Sunday	1	202301	January	2023	Jan-23	1	01/01/2023
02/01/2023	Jan-23	202301	Q1-2023	20231	0	Monday	2	202302	January	2023	Jan-23	1	02/01/2023
03/01/2023	Jan-23	202301	Q1-2023	20231	1	Tuesday	2	202302	January	2023	Jan-23	1	03/01/2023
04/01/2023	Jan-23	202301	Q1-2023	20231	2	Wednesday	2	202302	January	2023	Jan-23	1	04/01/2023
05/01/2023	Jan-23	202301	Q1-2023	20231	3	Thursday	2	202302	January	2023	Jan-23	1	05/01/2023
06/01/2023	Jan-23	202301	Q1-2023	20231	4	Friday	2	202302	January	2023	Jan-23	1	06/01/2023
07/01/2023	Jan-23	202301	Q1-2023	20231	5	Saturday	2	202302	January	2023	Jan-23	1	07/01/2023
08/01/2023	Jan-23	202301	Q1-2023	20231	6	Sunday	2	202302	January	2023	Jan-23	1	08/01/2023
09/01/2023	Jan-23	202301	Q1-2023	20231	0	Monday	3	202303	January	2023	Jan-23	1	09/01/2023
10/01/2023	Jan-23	202301	Q1-2023	20231	1	Tuesday	3	202303	January	2023	Jan-23	1	10/01/2023
11/01/2023	Jan-23	202301	Q1-2023	20231	2	Wednesday	3	202303	January	2023	Jan-23	1	11/01/2023
12/01/2023	Jan-23	202301	Q1-2023	20231	3	Thursday	3	202303	January	2023	Jan-23	1	12/01/2023
13/01/2023	Jan-23	202301	Q1-2023	20231	4	Friday	3	202303	January	2023	Jan-23	1	13/01/2023
14/01/2023	Jan-23	202301	Q1-2023	20231	5	Saturday	3	202303	January	2023	Jan-23	1	14/01/2023
15/01/2023	Jan-23	202301	Q1-2023	20231	6	Sunday	3	202303	January	2023	Jan-23	1	15/01/2023

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)