MaxDate Issue Calculated Column

[hasharma19]

Hell All,

I have dimdate table in my power bi structure which date calculated on basis of other table min and max date column.

Now I am trying to get the Max data using calculated column with expression as" DimDate[Date]<=MAX(Delivery_Exce[ERDF NC Date])", but it is always giving me true as output instead of true and false whereever the condition is not matching.

Please help me to get the correct calculation.

[Ahmedx]

could you share your pbix-file? Or create an example file which reproduces your issue?

[hasharma19]

@Ahmedx @Ahmedx Hi,

Since there is no option available/showing to attached the file.

i have created a table for ref. I have raw data file wherein three dates columns are available(dates are from 01/01/2021 to 20/05/2023).
I have creaated new date table -Calender[min(Raw_dataERDF_NC_Date),max(Raw_dataERDF_NC_Date)

Now have added calculated column in dimdate table as MaxDate- DimDate[Date]<=MAX(Raw_data[ERDF_NC_Date]). 

The output of max date is showing all value is true, whereas is should true for matched and false for unmatched as per DAX.

Raw_Data
Sid	Startdate	EDRF_NC_Date	EDRF_SC_Date
1111111	01-01-2021	03-01-2021	06-01-2021
1111112	02-01-2021	04-01-2021	07-01-2021
1111113	03-01-2021	05-01-2021	08-01-2021
1111114	04-01-2021	06-01-2021	09-01-2021
1111115	01-01-2022	03-01-2022	06-01-2022
1111116	02-01-2022	04-01-2022	07-01-2022
1111117	03-01-2022	05-01-2022	08-01-2022
1111118	04-01-2022	06-01-2022	09-01-2022
1111119	01-01-2023	03-01-2023	06-01-2023
1111120	02-01-2023	04-01-2023	07-01-2023
1111121	03-01-2023	05-01-2023	08-01-2023
1111122	04-01-2023	06-01-2023	09-01-2023

[Ahmedx]

you can upload the file to any cloud!

Do you have an established relationship between the date table and Raw_data?

[hasharma19]

@Ahmedx -New (1).pbix

[Ahmedx · Accepted solution]

Is this what you are looking for?

[hasharma19]

@Ahmedx  Yes, and if you check the trend line graph, the future % is showing 0.00% till week 52-2023

I want future should be blank and when the data entered for that week so the % should show like earlier week is showing.

[Ahmedx]

pls try this

[hasharma19]

@Ahmedx 
Thanks- The issue is now, when i am selection location from slicer whereever the performance 100%(which means 0.00% error in any particular week) then the trend line is missing.
i am expecting trend line show the actul performace which means no missing trend line in any week(if performace is 0.61%  or 0.00% then the trend link show accrsongly instead of missing link between weeks)

[hasharma19]

@Ahmedx Pls help in this case

[Ahmedx]

you have everything correct, but where should be False?

you write what you want to receive. maybe you need a max on level year ?

[hasharma19]

@Ahmedx Yes the relationship is there,
I can upload on ondrive(if you can share your email id in DM)

[hasharma19]

@johnt75  ,@Ahmedx 

-Can you please help in this case