Forum Discussion

danielboi's avatar
danielboi
Helper I
5 years ago
Solved

Avoiding filtered context with Variable. Help needed

Hello everybody,   making good progress with my Power Bi and now in fine tuning mode. I am building a financial report which is based on a download from our corporate data warehouse. (Very simplifi...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    danielboi , In the above I see one change , if that can work for you

     

    VAR DateMax =
    CALCULATE(
    MAXX(
    filter(allselected(FactFIRE),
    FactFIRE[Version ID]=2)    ,
    FactFIRE[Period ID]
    )
    )
    RETURN

danielboi's avatar
danielboi
Helper I
5 years ago

Hello amitchandak ,

 

I am aware of the YTD formulas, but as far as I know it would not allow me to use a slicer to look at any combination of periods as needed, e.g. only Q2 or June and Juli. Will try strip down the file, but might take a while.

 

At the end of the day I am just trying to extract the date without a filter context on the version (act/bud/fc)

 

Have a great day.