Forum Discussion

Lyvili's avatar
Lyvili
Frequent Visitor
2 years ago

Last Update & Range

Good afternoon, I am experimenting problems to find a solution.   I have 4 different sources (System1, System2, System3, System4) and each has a different update date. I need to show in a table da...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Lyvili , This need to be measure not a column in that case

 

Slicer Preselection = IF(MAX('Calendar'[Date])=[UltimaActualizacionComunSistemas], "Last Update", "Range")

 

 

and in case you need a slicer for this, you need segmentation 

 

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q