Forum Discussion

sk86's avatar
sk86
New Member
3 years ago

Previous month value - wrong metadata

Hi All,   initial dataset is as in the upper table - Client has a certain Sale in each month, from Jan till September - belongs to Hong-Kong office, later office gets changes to London. How to writ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

sk_86's avatar
sk_86
New Member
3 years ago

Hi Ashish,

 

thank you, this looks great. But how to make part with ",all(Office)" more generic? So let's say basically we should remove any filter on every possible table APART from Date and Client dimensions.

sth like this should work - REMOVEFILTERS(), KEEPFILTERS(Dates), KEEPFILTERS (Clients) ?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    You are welcome.  Try the ALLEXCEPT() function.