lundi 25 mai 2020

not getting correct logical output using if condition Power BI

I want to get data according to filtered date like i have filtered date 15 apr 2020 then if the eaxct date not present reporting date then the closest date before to filtered data to be fetched. mostly the data we are getting on 10th or 5th of month. image of the reports and fields i am using

like you can see image i have selected 15th in filter which i am getting through measure 2

Measure 2 = SELECTEDVALUE('Date'[Date],TODAY()) then i am getting date that are below or equal to filtered date in measure 4 Measure 4 = if([Measure 2]>=MIN(hello[Reporting Date]),1,0) if its below or equal then its sets 1 and if not then 0 in measure 5 i am trying to get date instead of 1 which is become number due datatype problem bt its ok. Measure 5 = IF([Measure 4]=1,CALCULATE(MAX(hello[try]),ALLSELECTED(hello[Loan Number])),0) now if i want to get the max value from measure 5 i have to get it in column filed because max works on only column so column asd

asd = IF( ([Measure 5]<>0),hello[Reporting Date],0) but its getting different out put as you can see in image. column named column i am fetching max asd value which is wrong because asd is calculating wrong Column = IF([Measure 4]=1,MAX(hello[asd]),0) i want only those field which are having 43931 which is closest date to the 15 apr 2020. you can see in reporting date. try date is same copy of reporting date i used it to try only its not making any difference

Aucun commentaire:

Enregistrer un commentaire