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?
Helper IISince 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) - hasharma19
- 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 ?