How to replace 2 GL expense expression into 1 ?

[admin11]

Hi All

I have make a post below  :-

https://community.powerbi.com/t5/Desktop/Convert-previous-month-expression-to-last-month-not-working...

with the help from  @jdbuchanan71  i get the below expression working fine :-

Current month - 1 EXP_ =

VAR _Start = EOMONTH ( TODAY (), -2 ) + 1

VAR _End = EOMONTH ( _Start, 0 )

RETURN

CALCULATE ( [AMOUNT_EXP], DATESBETWEEN ( 'Date'[Date], _Start, _End ) )

Current month - 2 EXP_ =

VAR _Start = EOMONTH ( TODAY (), -3 ) + 1

VAR _End = EOMONTH ( _Start, 0 )

RETURN

CALCULATE ( [AMOUNT_EXP], DATESBETWEEN ( 'Date'[Date], _Start, _End ) )

May i know how to convert the above expression into 1 , So user need only click on the  :-

month = 2 , get Current month - 1 EXP_ 

month = 1 , get Current month - 2 EXP_ 

Enclosed below is my PBI file :-

https://www.dropbox.com/s/j2vletdewwpeqkj/PBT_V2021_392%20TI_SI_GL%20how%20to%20combine%202%20expres...

Paul

[amitchandak · Accepted solution]

@admin11 , One way is you give him what if parameter and use that -https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Current month - 1 EXP_ =
VAR _Start = EOMONTH ( TODAY (), -1 * selectedvalue(Whatif[Value]) -1 ) + 1
VAR _End = EOMONTH ( _Start, 0 )
RETURN
CALCULATE ( [AMOUNT_EXP], DATESBETWEEN ( 'Date'[Date], _Start, _End ) )

or you can measure slicer to create button or list

measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[admin11]

@amitchandak 

wow your mind work very fast . 

Thank you so much , it work fine.

Paul