Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Converting static to Dynamic Measure

Hai All, I am expecting a super solution for this requirement. The requirement is  Currently I am working on a sales dashboard and every year this report is having different versions of tables for ...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please try something like

    Measure1 =
VAR LastDateWithData =
    CALCULATE ( MAX ( MASTER[Date] ), REMOVEFILTERS () )
VAR LastVerion =
    CALCULATE (
        MAX ( MASTER[Version] ),
        MASTER[Date] = LastDateWithData,
        REMOVEFILTERS ()
    )
RETURN
    CALCULATE (
        SUM ( Sales[Values] ) / 1000,
        MASTER[Version] = LastVerion,
        ALL ( MASTER[Comparison] )
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hai tamerj1 
This solution is not working , can i create two table for version?

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
I don't know how your data and data model look like.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hai tamerj1 
    Can you check this measure

     

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Anonymous 

      Try delete FILTER (

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hai tamerj1 

     


    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hai tamerj1 can you please help me to acheive this logic

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Good morning Anonymous 

      this is exactly what I was trying to do. Her is the explanation of my idea and let me know if anything does not seem right. 
      The latest verion corresponds to the latest date available in the MASTER table. I started with calculating the last date avialable in the master table by removing all filters. 
      using this date I calculated the corresponding version and again by removing all filters. 
      this should give me the last version which I can refer to in your measure. Not sure wht goes wrong? Please correct me if I missed something. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hai tamerj1  
        Can you suggest some other way based on version
        and 
        please guide this i am trying to solve through this

        I am trying to create a calculated column based max of forecast version column based on max version flag. but this is showing wrong 
        version flag represnts number of  each version