Forum Discussion

CharlesK's avatar
CharlesK
Frequent Visitor
8 years ago

DAX function to calculate basket size

So,   This is fascinating.   I have 2.5m+ transactions and the unique identifier, in my case, is the receipt number; which the table has. I am making the assumption that each individual receipt c...
Interesting Links
Need Help
Show and Tell
danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

Hi CharlesK,

 

Please post  a sample data that we can just copy paste and import into Power BI as well as your countif formula in Excel. 

CharlesK's avatar
CharlesK
Frequent Visitor
8 years ago

i've tried attaching something here couldnt manage

  • RMDNA's avatar
    RMDNA
    Icon for Solution Sage rankSolution Sage
    8 years ago

    CharlesK,

     

    Attach it through Dropbox/OneDrive/Google Drive.