Forum Discussion
MaxDate Issue Calculated Column
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.
Is this what you are looking for?
12 Replies
could you share your pbix-file? Or create an example file which reproduces your issue?
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 you can upload the file to any cloud!
Do you have an established relationship between the date table and Raw_data?
