Forum Discussion

Mat42's avatar
Mat42
Resolver I
6 years ago

Calculated Column - Latest Entry

I have a dataset that is a mix of quarterly data and annual data. It's similar to the simple example below:   The 'Current Quarter?' column is a calculated column that I've added that identif...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Mat42 ,

 

Does "measure" have corresponding date?

If so, try the DAX below:

Measure = IF(YEAR(TODAY())=MAX('Table'[Date].[Year]),"Y","N")
If the problem persists,could you please share more sample data or sample pbix?

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Mat42's avatar
    Mat42
    Resolver I
    6 years ago

    Thanks for your responses.

     

    The problem is that what I've shared is basically all there is. The measures don't have an assigned date, just Q1 Q2 etc or the 2015/2016, 2018-2019 designations. The rest of the table is just service specific data (levels, amounts etc) that match the measure. The example table is the only data not input on a quarterly basis.

     

    Is it possible, maybe, to use the Max function to create the column to add a Y to the last entry per annual measure? The quarter labels (Q1 etc) are easy to work with, but the year entries will vary. Sometimes the latest data will be 2019/2020, sometimes it might be 2016/2017. It really just needs to add a Y in for the latest year (for those measures that don't have Q1 etc.

    • Mat42's avatar
      Mat42
      Resolver I
      6 years ago

      Thanks for everyone's help.

       

      Turns out I was trying to do something that we don't actually need to do. Which would have been helpful to know a month ago.

      Anyway, thanks for the help.