Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Tableau to Power BI

// { FIXED [AUDITOR]: MAX(if YEAR([SCHDL_START_DATETIME])=year(today()) THEN [MAX_AUDIT_DAYS] END) }
//fixed max

Can any one explain how this wors in Power, and please provide the DAX function for this. I want to sow MIN days and Max Days for each month and year like this, here each line in line chart represent each year (2019,2020,2021)
 

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      i tried but couldnt get the expected result 

  • Anonymous's avatar
    Anonymous
    Not applicable

    can any one give any possible soltions for this ?

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion

    Anonymous  since this is a power bi forum, a lot of us are not actually fluent in tableau syntax.

     

    Therefore, is it kindly possible for you to provide a sample data and expected output and describe how do you desire to reach there. That can be very easily translated into a DAX expression.