Forum Discussion

razvancanuta's avatar
razvancanuta
Frequent Visitor
4 years ago

Cannot create calculate table in SSAS like I do in PowerBI

Hello, I have an issue when I try to create the same calculate table in SSAS as in PowerBI desktop The table looks like this: =SUMMARIZECOLUMNS(    Fact[Date],    Fact[CountryID],    Fact[Pro...
Need Help
Tips and Tricks
  • razvancanuta's avatar
    razvancanuta
    Frequent Visitor
    4 years ago

    Hi,

    Its giving me the same response "One or more formulas have errors", but only when I add the second filter option, even if I add the second one alone.

    Initially I had one more condition,  WEEKDAY( Facty[Date] )=WEEKDAY( MAX(Fact[Date]) ), but it gives me the same error.
    Seems like he likes only the DATESINPERIOD formula.