Forum Discussion

streep1's avatar
streep1
Regular Visitor
5 years ago

Current Week/Year Values - With two different data sets in the same table.

Hello I previously had a solved query regarding how to find the current week and the current year values by using -   CurrentWeekCurrentYear = VAR CurrYear = MAXX(allselected('Data'),'Data'[Cu...
Need Help
Tips and Tricks
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi streep1 ,

 

Can you attach the screenshot of your data model with the relationship?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

streep1's avatar
streep1
Regular Visitor
5 years ago

Hello

 

Apologies - The data just comes as a flat file, with the [data_set] field distinguishing between A and B 

 

Many thanks

 

P

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi streep1 ，

     

    Pls forgive my misunderstanding,do you wanna filter out the data by Date A and Date B?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!