Forum Discussion
Aggregation
Hi all, I have an issue with my data source and I need to be able to report on data in the charts and tables - basically front end. I need to go from the current state: Current State Date ...
Anonymous not entirely sure what you asking but i think you could probably do a switch statement
https://docs.microsoft.com/en-us/dax/switch-function-dax
create a calculated column
desired state column1 =
SWITCH ( [column1],
2, 5,
3, 3 )
Hi Anonymous ,
Could you please share your sample data or Pbix to me via One Drive, kindly upload the files and share the link here.
BTW, maybe your can try to create a calculated table of an Aggregation one by using SUMMARIZECOLUMNS function as below.
Table = SUMMARIZECOLUMNS('current'[Date],"co1",SUM(current[column1]),"co2",SUM(current[column2]))Hi v-frfei-msft ,
Many thanks for your suggestions.
I'll try to create a calculated table if that does not work - I'll share file with you.
Many thanks!
