Dynamic Conversion

[Anonymous]

Hai Users please help me with this 

This is the data model master table contains all dimension values and the sales table is a fact table

This is the fact table here I will append every version of data in this particular table, I have a data of V5- May -2021 to v4- April-2022

After I had created a version flag so based on this report will understand the max of version

And user want to see the report based on the latest version of data and they want to compare it with previous ones
Requirment is , After appedning every version table instead of write a static latest version(like which i marked in red)
I want to add dynamic latest version. And report should automatically  update with latest version.Even the new version of table appending
Hope it clear please reach out still you have any doubt

[Anonymous]

Hi @Anonymous ,

Is it possible to convert the [version] field to an whole number? For example, "V4-APR-22" could be written as 220404.

This way we can use Master[Version]=MAX(Master[Version]) to replace Master[Version]="V4-Apr-22" in the formula.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data