Forum Discussion
Helper IIMaxDate Issue Calculated Column
Is this what you are looking for?
Super Usercould you share your pbix-file? Or create an example file which reproduces your issue?
hasharma19Since 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 Yes the relationship is there,
I can upload on ondrive(if you can share your email id in DM)