Forum Discussion

CJKPowerBI's avatar
CJKPowerBI
Icon for Helper I rankHelper I
3 years ago
Solved

formula in excel make it in PowerBi

Hello all,   i have the below formula in excel which basically checks today's date and if before this month 23rd day then it puts the 15th of this month, if todays date is more than 23rd of this mo...
General Comment
Need Help
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    3 years ago

    CJKPowerBI 

    Please try

    Amount to be paid on =
IF (
    OR ( [Charge] = "Text 1", [Charge] = "Text 2" ),
    IF (
        DAY ( [Transcation Date] ) <= 23,
        DATE ( YEAR ( [Transcation Date] ), MONTH ( [Transcation Date] ) + 1, 15 ),
        EOMONTH ( [Transcation Date], 1 ) + 15
    ),
    [Transcation Date]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

CJKPowerBI 

Please paste your formula here in order to be able to amend. 

CJKPowerBI's avatar
CJKPowerBI
Icon for Helper I rankHelper I
3 years ago


Below is the formula:

 

Amount to be paid on = IF(OR(([Charge]="Text 1"),([Charge]="Text 2")),IF(DAY([Transcation Date]<=23,DATE(YEAR([Transcation Date],MONTH([Transcation Date])+1,15),EOMONTH([Transcation Date],1)+15),[Transcation Date])

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    CJKPowerBI 

    Please try

    Amount to be paid on =
IF (
    OR ( [Charge] = "Text 1", [Charge] = "Text 2" ),
    IF (
        DAY ( [Transcation Date] ) <= 23,
        DATE ( YEAR ( [Transcation Date] ), MONTH ( [Transcation Date] ) + 1, 15 ),
        EOMONTH ( [Transcation Date], 1 ) + 15
    ),
    [Transcation Date]
)
    • CJKPowerBI's avatar
      CJKPowerBI
      Icon for Helper I rankHelper I
      3 years ago

      thank you tamerj1  that worked great...